Sunday, February 19, 2012

How can I find out which filegroup a table belongs to?

Hi, everybody!
I made a database which has two filegroups. One is primary filegroup, and
the other is named FG_01.
I set FG_01 as default filegroup so that every table should be created on
it.
But I found today that a developer had created tables on primary filegroup.
I want to move these tables from primary filegroup to FG_01 filegroup.
But there are so many tables that it is difficult to find out which tables
are on primary filegroup.
How can I find out which filegroups a table belongs to by means of query?
Any advice would be appreciated.Hello Kim !
Try to use the undocumented Procedure to fugure out the Filegroups:
sp_objectfilegroup @.objid
HTH, Jens Süßmeyer.

No comments:

Post a Comment