list object with filegroup | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

list object with filegroup

Hello, I want list all object that are owned by a specific filegroup. Someone knows how can I do that?. I mean, I want to see the ‘content’ of the filegroup. For example: table1 filegroup1
table3 filegroup3
index3 filegruop1
etc..
actually, file group is by index, not table object
so the table could be in 1 fg, and each index in same or others anyways, join to sysindexes and use the groupid column
]]>