TABLECONSTRAINTS System Table Description

Description

Information about column and table check constraints defined.

Fields

Field Type Description

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.

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