SCHEMATA View¶
This Information Schema view displays a row for each schema in the specified (or current) database, including the INFORMATION_SCHEMA schema itself.
Columns¶
Column Name |
Data Type |
Description |
---|---|---|
CATALOG_NAME |
TEXT |
Database that the schema belongs to |
SCHEMA_NAME |
TEXT |
Name of the schema |
SCHEMA_OWNER |
TEXT |
Name of the role that owns the schema |
IS_TRANSIENT |
TEXT |
Whether this is a transient schema |
IS_MANAGED_ACCESS |
TEXT |
Whether the schema is a managed access schema |
RETENTION_TIME |
NUMBER |
Number of days that historical data is retained for Time Travel |
DEFAULT_CHARACTER_SET_CATALOG |
TEXT |
Not applicable for Snowflake. |
DEFAULT_CHARACTER_SET_SCHEMA |
TEXT |
Not applicable for Snowflake. |
DEFAULT_CHARACTER_SET_NAME |
TEXT |
Not applicable for Snowflake. |
SQL_PATH |
TEXT |
Not applicable for Snowflake. |
CREATED |
TIMESTAMP_LTZ |
Creation time of the schema |
LAST_ALTERED |
TIMESTAMP_LTZ |
Last altered time of the schema |
COMMENT |
TEXT |
Comment for this schema |
Usage Notes¶
The view only displays objects for which the current role for the session has been granted access privileges.