Export (0) Print
Expand All
Expand Minimize

sysconstraints

SQL Server 2000

Contains mappings of constraints to the objects that own the constraints. This system catalog is stored in each database.

Column name Data type Description
constid int Constraint number.
id int ID of the table that owns the constraint.
colid smallint ID of the column on which the constraint is defined, 0 if a table constraint.
spare1 tinyint Reserved.
status int Pseudo-bit-mask indicating the status. Possible values include:

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.

actions int Reserved.
error int Reserved.

Show:
© 2014 Microsoft