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.