B.14 Content of SQL_TABLE_CONSTRAINTS
SQL_TABLE_CONSTRAINTS stores constraint information related to base tables. Each row stores information on one constraint.
The following table describes the content of SQL_TABLE_CONSTRAINTS.
|
No. |
Column name |
Data type |
Stored information |
|---|---|---|---|
|
1 |
CONSTRAINT_SCHEMA |
VARCHAR(100) |
Schema name that includes a constraint |
|
2 |
CONSTRAINT_NAME |
VARCHAR(100) |
Constraint name |
|
3 |
CONSTRAINT_TYPE |
CHAR(1) |
Constraint type
|
|
4 |
TABLE_SCHEMA |
VARCHAR(100) |
Schema name of a table for which a constraint is defined |
|
5 |
TABLE_NAME |
VARCHAR(100) |
Table identifier of a table for which a constraint is defined |