Column name
|
Data type
|
Description
|
| CONSTRAINT
_CATALOG |
VARCHAR(128) |
The name of the catalog containing the table constraint. |
| CONSTRAINT_SCHEMA |
VARCHAR(128) |
The name of the schema containing the table or view. |
| CONSTRAINT_NAME |
VARCHAR(128) |
The name of the table constraint. |
| TABLE_CATALOG |
VARCHAR(128) |
The name of the catalog containing the table or view. |
| TABLE_SCHEMA |
VARCHAR(128) |
The name of the schema containing the table or view. |
| TABLE_NAME |
VARCHAR(128) |
The name of the table or view. |
| CONSTRAINT_TYPE |
VARCHAR(20) |
One of:
"CHECK"
"FOREIGN KEY"
"PRIMARY KEY"
"UNIQUE". |
| IS_DEFERRABLE |
VARCHAR(3) |
One of:
"YES" = the constraint is deferrable
"NO" = the constraint is not deferrable. |
| INITIALLY_DEFERRED |
VARCHAR(3) |
One of:
"YES" = the constraint is immediate
"NO" = the constraint is deferred. |
