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
> SELECT catalog_name
FROM information_schema.information_schema_catalog_name
default