TABLECONSTRAINTS System Table Description

Description

Information about column and table check constraints defined.

Fields

Field Type Description
TABLENAME string The name of the table on which the constraint is placed.
SCHEMA string The name of the schema for the table on which the constraint is placed.
CONSTRAINTNAME string For column check constraints, the CONSTRAINTNAME column stores the column name for which the check constraint has been defined. For table check constraints, the CONSTRAINTNAME column contains a system generated constraint name of tablename plus a $constraintN suffix.
CONSTRAINTTEXT text Stores the check constraint logic.

Indexes

Primary Index: TABLECONSTRAINTS..PRIMARY_KEY on fields: SCHEMA, TABLENAME, CONSTRAINTNAME