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:


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.
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 by a user who holds the MANAGE GRANTS privilege.

  • To remove the INFORMATION_SCHEMA views from your queries, filter using a WHERE clause, e.g.:

    ... WHERE table_schema != 'INFORMATION_SCHEMA'