Hi!!!
I would like to know what filegroup is in the table or what tables are in the filegroup, using SELECT.
Excume my english.
Thank you.May check DBCC CHECKFILEGROUP which returns part of information required.|||It is found in sysindexes.
The data pages will be id = 0 if no clustered index or 1 if there is a clustered index.
groupid will give the filegroup id.
You can find the filegroup corresponding to the groupid in sysfiles.
Showing posts with label excume. Show all posts
Showing posts with label excume. Show all posts
Wednesday, March 21, 2012
Subscribe to:
Posts (Atom)