नोट
इस पेज तक पहुँच के लिए प्रमाणन की आवश्यकता होती है. आप साइन इन करने या निर्देशिकाओं को बदलने का प्रयास कर सकते हैं.
इस पेज तक पहुँच के लिए प्रमाणन की आवश्यकता होती है. आप निर्देशिकाओं को बदलने का प्रयास कर सकते हैं.
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
SELECT schema_owner
FROM information_schema.schemata
WHERE schema_name = 'information_schema'
AND catalog_name = 'main'