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.