Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Determine Tables on FileGroup
Message
From
17/01/2004 05:20:09
 
General information
Forum:
Microsoft SQL Server
Category:
Database management
Miscellaneous
Thread ID:
00867490
Message ID:
00867765
Views:
15
Check the sysfiles system table and sysobjects.

The below query lists all objects on a particular file group.

select name from sysobjects
where id in (select id from sysindexes
where name = 'data file name')
Previous
Reply
Map
View

Click here to load this message in the networking platform