Important

Helios features are now enabled during weekly update windows and are no longer directly tied to SingleStore engine releases. Refer to the release notes to view the latest features available in your Helios cluster.

KEY_COLUMN_USAGE

This view contains information about columns that are part of unique keys (constraints) and displays one row per column in a unique constraint.

Column Name

Description

CONSTRAINT_CATALOG

This value is always def.

CONSTRAINT_SCHEMA

The name of the related schema (database) for a given key column.

CONSTRAINT_NAME

The name of the related constraint for a given key column.

TABLE_CATALOG

Value is always def.

TABLE_SCHEMA

The name of the related schema (database) for a given key column.

TABLE_NAME

The name of the related table for a given key column.

COLUMN_NAME

The name of a given key column.

ORDINAL_POSITION

The column’s position within the key. (These are numbered beginning with 1.)

POSITION_IN_UNIQUE_CONSTRAINT

Always NULL.

REFERENCED_TABLE_SCHEMA

Always NULL.

REFERENCED_TABLE_NAME

Always NULL.

REFERENCED_COLUMN_NAME

Always NULL.

Last modified:

Was this article helpful?