PRIMARY_KEYS
Provides primary key information.
Provides primary key information.
| Column Name | Data Type | Description |
|---|---|---|
CONSTRAINT_ID |
INTEGER | A unique numeric ID assigned by the Vertica catalog, which identifies the constraint. |
CONSTRAINT_NAME |
VARCHAR | The constraint name for which information is listed. |
COLUMN_NAME |
VARCHAR | The column name for which information is listed. |
ORDINAL_POSITION |
VARCHAR | The position of the column within the key. The numbering of columns starts at 1. |
TABLE_NAME |
VARCHAR | The table name for which information is listed. |
CONSTRAINT_TYPE |
VARCHAR |
The constraint type, p, for primary key. |
| IS_ENABLED` | BOOLEAN | Indicates if a table column constraint for a PRIMARY KEY is enabled by default. Can be t (True) or f (False). |
TABLE_SCHEMA |
VARCHAR | The schema name for which information is listed. |