status The type of the integrity constraint: 1 = PRIMARY KEY constraint; 2 = UNIQUE KEY constraint; 3 = FOREIGN KEY constraint; 4 = CHECK constraint; 5 = DEFAULT constraint; 16 = column-level constraint; 32 = table-level constraint
7>
8>
9> select top 10 * from sysconstraints;
10> GO
constid id colid spare1 status actions error
----------- ----------- ------ ------ ----------- ----------- -----------
1131151075 1115151018 6 0 133141 4096 0
(1 rows affected)
|