Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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