INFORMATION_SCHEMA_CATALOG_NAME

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

INFORMATION_SCHEMA.INFORMATION_SCHEMA_CATALOG_NAME returns the name of this information schema's catalog.

Definition

The INFORMATION_SCHEMA_CATALOG_NAME relation contains the following columns:

Name	Data type	Nullable	Standard	Description
CATALOG_NAME	STRING	No	Yes	The name of the catalog containing this information schema.

Constraints

The following constraints apply to the INFORMATION_SCHEMA_CATALOG_NAME relation:

Class	Name	Column List	Description
Primary key	INFOCAT_PK	CATALOG_NAME	Unique identifier the catalog
Foreign key	INFOCAT_CATS_FK	CATALOG_NAME	References CATALOGS.

Examples

SQL

> SELECT catalog_name
    FROM information_schema.information_schema_catalog_name
  default

Related

• Information schema
• INFORMATION_SCHEMA.CATALOGS