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:
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'