CONSTRAINT_COLUMNS

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_SCHEMA`	VARCHAR	Name of the schema that contains this table.
`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 thereferenced 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.