SCHEMATA
Applies to: 
Databricks SQL Databricks Runtime 10.4 LTS and above Unity Catalog only
INFORMATION_SCHEMA.SCHEMATA describes schemas within the catalog.
The rows returned are limited to the schemas the user has permission to interact with.
Definition
The SCHEMATA relation contains the following columns:
| Name | Data type | Nullable | Standard | Description |
|---|---|---|---|---|
CATALOG_NAME | STRING | No | Yes | Catalog containing the schema. |
SCHEMA_NAME | STRING | No | Yes | Name of the schema. |
SCHEMA_OWNER | STRING | No | No | User or group (principal) that currently owns the schema. |
COMMENT | STRING | Yes | No | An optional comment that describes the relation. |
CREATED | TIMESTAMP | No | No | Timestamp when the relation was created. |
CREATED_BY | STRING | No | No | Principal which created the relation. |
LAST_ALTERED | TIMESTAMP | No | No | Timestamp when the relation definition was last altered in any way. |
LAST_ALTERED_BY | STRING | No | No | Principal which last altered the relation. |
Constraints
The following constraints apply to the TABLES relation:
| Class | Name | Column List | Description |
|---|---|---|---|
| Primary key | SCHEMATA_PK | CATALOG_NAME, SCHEMA_NAME | Unique identifier for the schema. |
| Foreign key | SCHEMATA_CATS_FK | CATALOG_NAME | References CATALOGS. |
Examples
SQL
SELECT schema_owner
FROM information_schema.schemata
WHERE schema_name = 'information_schema'
AND catalog_name = 'main'