All databases
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.
The columns for sysconstraints are:
Name |
Datatype |
Description |
|---|---|---|
colid |
smallint |
Column number in the table |
constrid |
int |
Object ID of the constraint |
tableid |
int |
ID of the table on which the constraint is declared |
error |
int |
Constraint-specific error message |
status |
int |
The type of constraint:
|
spare2 |
int |
Unused |
Unique clustered index on tableid, colid
Nonclustered index on constrid
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
