INFORMATION_SCHEMA_CATALOG_NAME

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime 10.4 LTS and above check marked yes 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 

> SELECT catalog_name
    FROM information_schema.information_schema_catalog_name
  default