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
Read More...