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.

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'