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 |
|
carumuga
Posting Yak Master
174 Posts |
 Posted - 2008-08-06 : 05:24:15
|
| Hi,In sysindexes, what is the max value of indid column it can hold.It has both clustered and non-clustered index.0-> No index defined1->clustered index1> -> Non clustered index.In the BOL, it is mentioned that anything > 1 is nonclustered index.But would like to know the max value the indid column can hold. Is it 255 for both clustered and non-clustered index? |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-08-06 : 05:33:55
|
have you try using sp_help on sysindexes ?sp_help sysindexes
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-06 : 23:43:02
|
| Each table can only have 250 indexes, 1 clustered and 249 non-clustered. |
|
|
|
carumuga
Posting Yak Master
174 Posts |
Posted - 2008-10-20 : 05:41:06
|
| Why Nonclustered index is in the range 2 and 254 in the sysindexes table.Your suggestion is highly appreciated |
|
|
|
|
|
|
sysindexes