The SYS_KEY_COLUMN_USAGE table provides metadata that maps columns to key constraints.
| Column name | Data type | Description |
|---|---|---|
CONSTRAINT_CATALOG |
VARCHAR(128) |
Top-level container for constraints. Not used. Always NULL. |
CONSTRAINT_SCHEMA |
VARCHAR(128) |
Second-level container for constraints. Not used. Always NULL. |
CONSTRAINT_NAME |
VARCHAR(128) |
The name of the constraint. |
TABLE_CATALOG |
VARCHAR(128) |
Top-level container for tables. Not used. Always NULL. |
TABLE_SCHEMA |
VARCHAR(128) |
Second-level container for tables. Not used. Always NULL. |
TABLE_NAME |
VARCHAR(128) |
The name of the Salesforce object to which the field belongs. |
COLUMN_NAME |
VARCHAR(128) |
The name of a Salesforce object field. |
ORDINAL_POSITION |
INT |
The position of the field in the key. Always 1, because the primary keys in Salesforce always consist of the single ID field. |