查询所有数据库数据文件的SQL

SELECT b.name,a.physical_name
FROM master.sys.master_files as a , sys.databases as b
where a.database_id = b.database_id
and a.physical_name not like '%.ldf'
and b.name not in ('master','tempdb','msdb','model','LitespeedLocal')
order by b.name