sysconstraints

All databases

Description

Whenever a user declares a new check constraint or referential constraint using create table or alter table, Adaptive Server inserts a row into the sysconstraints table. The row remains until a user executes alter table to drop the constraint. Dropping a table by executing drop table removes all rows associated with that table from the sysconstraints table.

This table also contains one row for each check constraint, referential constraint, computed column, and function-based index key associated with a specific table.

Columns

The columns for sysconstraints are:

Indexes

• Unique clustered index on tableid, colid

• Nonclustered index on constrid