CONSTRAINT_TABLE_USAGE

Applies to: Databricks SQL Databricks Runtime 11.3 LTS and above Unity Catalog only

Preview

This feature is in Public Preview. You can confirm preview enrollment on the Previews page. See Manage Databricks previews.

INFORMATION_SCHEMA.CONSTRAINT_TABLE_USAGE lists all constraints that reference a table as either a foreign or primary key within the catalog.

The rows returned are limited to the tables the user is privileged to interact with.

Definition

The CONSTRAINT_TABLE_USAGE relation contains the following columns:

Name	Data type	Nullable	Standard	Description
TABLE_CATALOG	STRING	No	Yes	Catalog containing the relation.
TABLE_SCHEMA	STRING	No	Yes	Schema containing the relation.
TABLE_NAME	STRING	No	Yes	Name of the relation.
CONSTRAINT_CATALOG	STRING	No	Yes	Catalog containing the constraint.
CONSTRAINT_SCHEMA	STRING	No	Yes	Schema containing the constraint.
CONSTRAINT_NAME	STRING	No	Yes	Name of the constraint.

Constraints

The following constraints apply to the CONSTRAINT_TABLE_USAGE relation:

Class	Name	Column List	Description
Primary key	CON_TAB_USG_PK	TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, CONSTRAINT_CATALOG, CONSTRAINT_SCHEMA, CONSTRAINT_NAME	Uniquely identifies the relation.
Foreign key	CON_TAB_USG_TABLES_FK	TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME	References TABLES
Foreign key	CON_TAB_USG_TAB_CONS_FK	CONSTRAINT_CATALOG, CONSTRAINT_SCHEMA, CONSTRAINT_NAME	References TABLE_CONSTRAINTS.

Examples

SQL

> SELECT constraint_name
    FROM information_schema.constraint_table_usage
    WHERE table_schema = 'information_schema'
      AND table_name = 'tables'

Related

• Information schema
• INFORMATION_SCHEMA.TABLE_CONSTRAINTS
• INFORMATION_SCHEMA.TABLES