Post reply

What Objects are on a FileGroup?

  • May 18, 2004 at 9:13 am

    #82680

    What is the best way to obtain a list of which tables or indexes are on a FileGroup?

  • May 18, 2004 at 10:17 am

    #506815

    I found one way to get the information:

    select a.name, b.name,a.groupid

    from sysindexes a,

    sysfiles b

    where a.groupid = b.groupid

    order by b.name,a.name

    Maybe there is a better way,... but couldn't find   sp_helpFileGroupObjects  

  • May 18, 2004 at 11:35 am

    #506832

    That's the only way I know and it only works for indexes or tables that have a clustered indexes. not sure how to determine for Stored procedures, heaps, views, etc.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply