INFORMATION_SCHEMA_CATALOG_NAME

  • Article

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