CONSTRAINT_COLUMNS

Records information about table column constraints.

Records information about table column constraints.

Column Name Data Type Description
CONSTRAINT_ID INTEGER Unique numeric ID assigned by the Vertica catalog that identifies the constraint.
TABLE_NAMESPACE VARCHAR For Eon Mode databases, name of the namespace that contains the table.
TABLE_SCHEMA VARCHAR

Name of the schema that contains this table.

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, n1.s refers to schema s in namespace n1.

TABLE_ID INTEGER 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

The constraint type, one of the following:

  • c: check

  • f: foreign

  • n: not null

  • p: primary

  • u: unique

IS_ENABLED BOOLEAN Indicates whether a constraint for a primary key, unique key, or check constraint is currently enabled.
REFERENCE_TABLE_ID INTEGER Catalog-assigned integer value that uniquely identifies the referenced table
REFERENCE_TABLE_NAMESPACE VARCHAR For Eon Mode databases, references the TABLE_NAMESPACE column in the PRIMARY_KEYS table.
REFERENCE_TABLE_SCHEMA VARCHAR

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, n1.s refers to schema s in namespace n1.

REFERENCE_TABLE_NAME VARCHAR References the TABLE_NAME column in the PRIMARY_KEYS table.
REFERENCE_COLUMN_NAME VARCHAR References the COLUMN_NAME column in the PRIMARY_KEYS table.

Privileges

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