MS SQL Server - Is there a way to see all tables(objects ) that a particular filegroup contains?

Author

Is there a way to see all tables(objects ) that a particular filegroup contains?

war_wheelan@yahoo.com

2006-10-24, 6:31 pm

Is there a way to see all tables (objects ) that a particular filegroup
contains without having to open each individual table?

I have a large db and keep tables in different filegroups based on how
frequently they are accessed. These filegroups are spread across
multiple drives with the most frequently accessed filegroup/tables on
the fastest drive.

Thanks,

Tibor Karaszi

2006-10-24, 6:31 pm

Yes, through the system tables/catalog views. To be more precise, we need to know what version of
SQL Server

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/

<war_wheelan@yahoo.com> wrote in message
news:1159209697.244507.221970@i42g2000cwa.googlegroups.com...
> Is there a way to see all tables (objects ) that a particular filegroup
> contains without having to open each individual table?
>
> I have a large db and keep tables in different filegroups based on how
> frequently they are accessed. These filegroups are spread across
> multiple drives with the most frequently accessed filegroup/tables on
> the fastest drive.
>
> Thanks,
>

war_wheelan@yahoo.com

2006-10-24, 6:31 pm

Tibor,

Thanks for the response. Since posting this question, I discovered the
'DBCC CHECKFILEGROUP' command, but I would also like to check out your
suggestion.

By the way, I am running SQL Server 2000 SP3

Tibor Karaszi wrote:[color=darkred
]
> Yes, through the system tables/catalog views. To be more precise, we need to know what version of
> SQL Server
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www. solidqualitylearning
.com/
>
>
> <war_wheelan@yahoo.com> wrote in message
> news:1159209697.244507.221970@i42g2000cwa.googlegroups.com...

Sponsored Links