CONSTRAINT_ID

INTEGER

A unique numeric ID assigned by the Vertica catalog, which identifies the constraint.

TABLE_SCHEMA

VARCHAR

Name of the schema that contains this table.

TABLE_ID

INTEGER

A unique numeric ID assigned by the Vertica catalog that identifies the table.

TABLE_NAME

VARCHAR

Name of the table in which the column resides.

COLUMN_NAME

VARCHAR

Name of the column that is constrained. For check constraints, if more than one column is referenced, each appears as a separate row.

CONSTRAINT_NAME

VARCHAR

Constraint name for which information is listed.

CONSTRAINT_TYPE

CHAR

Indicates the constraint type.

Valid Values:

• c — check
• f — foreign
• n — not null
• p — primary
• u — unique

IS_ENABLED

BOOLEAN

Indicates if a constraint for a primary key, unique key, or check constraint is currently enabled. Can be t (True) or f (False).

REFERENCE_TABLE_ID

INTEGER

Catalog-assigned integer value that uniquely identifies the referenced table

REFERENCE_TABLE_SCHEMA

VARCHAR

Schema name for which information is listed.

REFERENCE_TABLE_NAME

VARCHAR

References the TABLE_NAME column in the PRIMARY_KEY table.

REFERENCE_COLUMN_NAME

VARCHAR

References the COLUMN_NAME column in the PRIMARY_KEY table.