VIEWS View¶

This Information Schema view displays a row for each view in the specified (or current) database, including the INFORMATION_SCHEMA views for the database.

See also:: TABLES View

Columns¶

Column Name	Data Type	Description
TABLE_CATALOG	TEXT	Database that the view belongs to.
TABLE_SCHEMA	TEXT	Schema that the view belongs to.
TABLE_NAME	TEXT	Name of the view.
TABLE_OWNER	TEXT	Name of the role that owns the view.
VIEW_DEFINITION	TEXT	Text of the view’s query expression.
CHECK_OPTION	TEXT	Not applicable for Snowflake.
IS_UPDATABLE	TEXT	Not applicable for Snowflake.
INSERTABLE_INTO	TEXT	Not applicable for Snowflake.
IS_SECURE	TEXT	Specifies whether the view is secure.
CREATED	TIMESTAMP_LTZ	Creation time of the view.
LAST_ALTERED	TIMESTAMP_LTZ	Last altered time of the view.
LAST_DDL	TIMESTAMP_LTZ	Timestamp of the last DDL operation performed on the table or view, including database refreshes for replication (if the refresh changes visible properties for the table/view).
LAST_DDL_BY	TEXT	Username of the user who performed the last DDL operation on the table or view.
COMMENT	TEXT	Comment for this view.

Usage Notes¶

The view only displays objects for which the current role for the session has been granted access privileges. The view does not honor the MANAGE GRANTS privilege and consequently may show less information compared to a SHOW command when both are executed with a role that was granted the MANAGE GRANTS privilege.

This behavior also applies to other account-level privileges and Information Schema views for which there is a corresponding SHOW command.
To remove the INFORMATION_SCHEMA views from your queries, filter using a WHERE clause, e.g.:

... WHERE table_schema != 'INFORMATION_SCHEMA'