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

Date and time the object was last altered. See Usage Notes.

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.

  • The LAST_ALTERED column is updated when the following operations are performed on an object:

    • DDL operations.

    • DML operations (for tables only).

    • Background maintenance operations on metadata performed by Snowflake.