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_NAMESPACE_ID |
VARCHAR | For Eon Mode databases, unique numeric identifier of the namespace that contains the table. |
TABLE_NAMESPACE |
VARCHAR | For Eon Mode databases, name of the namespace that contains the table. |
TABLE_SCHEMA |
VARCHAR |
The schema name for which information is listed. If the schema belongs to a non-default namespace in an Eon Mode database, the schema name is front-qualified with the name of the schema's namespace. For example, |