Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Filegroup

Status
Not open for further replies.
Andel

Andel

Programmer
Feb 15, 2001
366
US
When you create a table or an index, you can specify which filegroup you want your table or index to reside. Now, is there a command that list what's inside a filegroup? Like what tables is in that filegroup? I appreciate all responses. Andel
andelbarroga@hotmail.com
 
Sort by date Sort by votes
I got it... they're in sysfilegroups table. connect it from sysobjects --> sysindexes --> sysfilegroups.
Andel
andelbarroga@hotmail.com
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

stanlyn
  • Locked
  • Question
Addressing FileGroup Tables & Fields
Replies
1
Views
128
stanlyn
stanlyn
gbaughma
  • Locked
  • Question
Filegroup is full....
Replies
12
Views
283
gbaughma
gbaughma
gbaughma
  • Locked
  • Question
Different filegroup for indexes?
Replies
1
Views
151
markros
markros
kodaksmile
  • Locked
  • Question
how to move objects to new filegroup
Replies
2
Views
109
kodaksmile
kodaksmile
mflancour
  • Locked
  • Question
Set filegroup to read only sql 2005 2
Replies
7
Views
241
mflancour
mflancour

Part and Inventory Search

Sponsor

Back
Top