PRIMARY_KEYS
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, |
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. |