Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)


By Krishna Sonti,

If we give SP_HELP , we'll know to which File Group the table belongs.
If we give SP_HELPFILEGROUP , we'll know the logical and physical file names along with other information that belong to the given File Group.
But have you ever tried that, given a file group, how to find all the tables that belong to that file group?
OR You want to know what are all the tables that belong to each file group. Here are two different ways of querying such possibilities.

Total article views: 131 | Views in the last 30 days: 1
Related Articles

to which DB these tables belong

to which DB these tables belong


A user belongs to multiple groups

Hello, I'm a bit confused about permissions. If a user, User1, belong to multiple groups, say ...


Get a listing of table names on a particular file group

I need to get a listing of tables belonging to a particular file group


SSC Editorial: Does Log Data Belong in a Table or a File?

I think the topic of whether log data belongs in a table or a file would be a great one for...