Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Meaning of status column in sysindexes table
Message
From
13/03/2000 16:40:10
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Meaning of status column in sysindexes table
Miscellaneous
Thread ID:
00345154
Message ID:
00345154
Views:
93
I'm probably missing something, but according to our T-Sql manual, the status of column of the sysindexes table should have the following values with the following meanings:

1 = Cancel command if attempt to insert
duplicate key.
2 = Unique index.
4 = Cancel command if attempt to insert
duplicate row.
16 = Clustered index.
64 = Index allows duplicate rows.
2048 = Index used to enforce PRIMARY KEY
constraint.
4096 = Index used to enforce UNIQUE constraint

Instead I see values like 18,2113554,16402. Please, how do I interpet these values? 18 could be the addion of 16 and 2. but what the heck produces 2113554?

Thanks
Thanks

Gar W. Lipow
Next
Reply
Map
View

Click here to load this message in the networking platform