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