系统表sysindexes中的status对应的解释???

有没知道系统表sysindexes中的status对应的解释???
case when i.status = 0 then '普通索引'
when i.status = 2 then '唯一索引'
when i.status = 16 then '聚簇索引'
when i.status = 2048 then '主键索引'
when i.status = 2050 then '主键唯一索引'
when i.status = 16402 then '聚簇唯一索引'
when i.status = 2097152 then '有字段允许为空的普通索引'
when i.status = 2097154 then '有字段允许为空的唯一索引'
else convert(varchar(20),i.status) end
但是还有其它不知道的类型,哪位大虾有相应的资料,请帮忙啦?
比如:18,2113554,16403,8388704,10485856,18450等???

---------------------------------------------------------------

status int Internal system-status information:
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.

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus