B.17 Content of SQL_REFERENTIAL_CONSTRAINTS
SQL_REFERENTIAL_CONSTRAINTS stores information related to referential constraints. Each row stores information on one referential constraint.
The following table describes the content of SQL_REFERENTIAL_CONSTRAINTS.
|
No. |
Column name |
Data type |
Stored information |
|---|---|---|---|
|
1 |
CONSTRAINT_SCHEMA |
VARCHAR(100) |
Schema name, including a referential constraint |
|
2 |
CONSTRAINT_NAME |
VARCHAR(100) |
Constraint name of referential constraint |
|
3 |
TABLE_SCHEMA |
VARCHAR(100) |
Schema name of the table for which the referential constraint is defined |
|
4 |
TABLE_NAME |
VARCHAR(100) |
Table identifier of the table for which the referential constraint is defined |
|
5 |
PRIMARY_CONSTRAINT_SCHEMA |
VARCHAR(100) |
Schema name, including a constraint referenced by a foreign key |
|
6 |
PRIMARY_CONSTRAINT_NAME |
VARCHAR(100) |
Constraint name referenced by a foreign key |
|
7 |
REFERENCED_TABLE_SCHEMA |
VARCHAR(100) |
Schema name of a referenced table |
|
8 |
REFERENCED_TABLE_NAME |
VARCHAR(100) |
Table identifier of a referenced table |
|
9 |
IS_DISABLE |
CHAR(1) |
Whether referential constraint check suppression is specified
|