Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jpham
Starting Member
19 Posts |
 Posted - 2006-09-19 : 18:49:39
|
| Hi All.How to find out the file group of the table’s index.So I have a table called TABLEA and there is index is created for this table. Is there a way that I can get the filegroup/table space of the index for this tableYour help is greatly appreciated.Thanks,JP |
|
|
jpham
Starting Member
19 Posts |
Posted - 2006-09-19 : 19:33:59
|
| Hi all,Actually I have two questions:1) I have the TABLEA and I want to find out what the filegroup(sysfilegroups.groupname) that the TABLEA is created on 2) Also I want to find out what is the filegroup of the primary keyof the TABLEA is created on. I only know the table name which is TABLEA andI want to find out what is the filegroup of the primary index of the TABLEA.ThanksJP |
 |
|
|
JoeNak
Constraint Violating Yak Guru
292 Posts |
Posted - 2006-09-20 : 07:54:12
|
| sp_help 'TABLEA' |
|
|
|
|
|
|
Get the file group of the primary key