SqlServer-QA.net

Here is the script I have used to list the information regarding database objects such as tables, indexes and file groups along with their file names :    (extracted from Technet) select 'table_name'=object_name(i.id)  ,i.indid,'index_name'=i.name  ,i.groupid,'filegroup'=f.name  ...