sysconstraints System Table - SQL Server 2000

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

Column nameData typeDescription
constidintConstraint number.
idintID of the table that owns the constraint.
colidsmallintID of the column on which the constraint is defined, 0 if a table constraint.
statusintBitmap 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.