This system table contains information about referenced table columns of all constraints to which the current user has access. All users have access to the table.
| Column Name | Description |
|---|---|
| CONSTRAINT_SCHEMA | Associated schema |
| CONSTRAINT_TABLE | Associated table |
| CONSTRAINT_TYPE | Constraint type (PRIMARY KEY, FOREIGN KEY or NOT NULL) |
| CONSTRAINT_NAME | Name of the constraint |
| CONSTRAINT_OWNER | Owner of the constraint (which is the owner of the table) |
| ORDINAL_POSITION | Position of the column in the table beginning at 1 |
| COLUMN_NAME | Name of the column |
| REFERENCED_SCHEMA | Referenced schema (only for foreign keys) |
| REFERENCED_TABLE | Referenced table (only for foreign keys) |
| REFERENCED_COLUMN | Name of the column in the referenced table (only for foreign keys) |