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 |
---|---|---|---|---|
|
|
No |
Yes |
Catalog containing the schema. |
|
|
No |
Yes |
Name of the schema. |
|
|
No |
No |
User or group (principal) that currently owns the schema. |
|
|
Yes |
No |
An optional comment that describes the relation. |
|
|
No |
No |
Timestamp when the relation was created. |
|
|
No |
No |
Principal which created the relation. |
|
|
No |
No |
Timestamp when the relation definition was last altered in any way. |
|
|
No |
No |
Principal which last altered the relation. |
Constraints
The following constraints apply to the TABLES
relation:
Class |
Name |
Column List |
Description |
---|---|---|---|
Primary key |
|
|
Unique identifier for the schema. |
Foreign key |
|
|
References CATALOGS. |