CONSTRAINT_COLUMNS

Records information about table column constraints.

Column Name Data Type Description
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.

Privileges

Non-superuser: No explicit privileges required. You only see records for tables that you have privileges to view.