CONSTRAINTS
The system table DOMAIN.CONSTRAINTS contains the CONSTRAINT definitions for all the tables for which the current user has privileges.
|
SCHEMANAME |
CHAR(32) |
Name of the schema of the table |
|
OWNER |
CHAR(32) |
Name of the owner of the table |
|
TABLE NAME |
CHAR(32) |
Name of table with the CONSTRAINT definition |
|
CONSTRAINT NAME |
CHAR(32) |
Name of the CONSTRAINT definition |
|
CONSTRAINT TYPE |
CHAR(12) |
Type of the CONSTRAINT definition (CHECK | KEY) |
|
DEFINITION |
CLOB |
Text of the CONSTRAINT definition |
Evaluating System Tables, CONSTRAINTS
SQL Reference Manual, CONSTRAINT Definition (constraint_definition)