TABLE_CONSTRAINTS

Provides information about table constraints.

Provides information about table constraints.

Column Name Data Type Description
CONSTRAINT_ID INTEGER Catalog-assigned integer value that uniquely identifies theconstraint.
CONSTRAINT_NAME VARCHAR The name of the constraint, if specified as UNIQUE, FOREIGN KEY, NOT NULL, PRIMARY KEY, or CHECK.
CONSTRAINT_SCHEMA_ID INTEGER Catalog-assigned integer value that uniquely identifies theschema containing the constraint.
CONSTRAINT_KEY_COUNT INTEGER The number of constraint keys.
FOREIGN_KEY_COUNT INTEGER The number of foreign keys.
TABLE_ID INTEGER Catalog-assigned integer value that uniquely identifies thetable.
TABLE_NAME VARCHAR The name of the table that contains the UNIQUE, FOREIGN KEY, NOT NULL, or PRIMARY KEY constraint
FOREIGN_TABLE_ID INTEGER The unique object ID of the foreign table referenced in a foreign key constraint (zero if not a foreign key constraint).
CONSTRAINT_TYPE CHAR

Indicates the constraint type.

Valid Values:

  • c — check

  • f — foreign

  • p — primary

  • u — unique

IS_ENABLED BOOLEAN Indicates if a constraint for a primary key, unique key, or check constraint is currently enabled. Can be t (True) or f (False).
PREDICATE VARCHAR For check constraints, the SQL expression.

See also

ANALYZE_CONSTRAINTS