views

The views view provides information about all views defined in the database.

Column name	Data type	Description
table_catalog	sql_identifier	The name of the current database containing the view.
table_schema	sql_identifier	The name of the schema containing the view.
table_name	sql_identifier	The name of the view.
view_definition	character_data	The query expression defining the view. NULL – The view is not owned by a currently enabled role.
check_option	character_data	Specifies whether the view enforces a CHECK OPTION. The possible values are: CASCADED – The option applies to all underlying views. LOCAL – The option applies only to this view. NONE – No CHECK OPTION is defined.
is_updatable	yes_or_no	Specifies whether the view is updatable (YES) or not (NO).
is_insertable_into	yes_or_no	Specifies whether the view is insertable (YES) or not (NO).
is_trigger_updatable	yes_or_no	Specifies whether the view has an INSTEAD OF UPDATE trigger (YES) or not (NO).
is_trigger_deletable	yes_or_no	Specifies whether the view has an INSTEAD OF DELETE trigger (YES) or not (NO).
is_trigger_insertable_into	yes_or_no	Specifies whether the view has an INSTEAD OF INSERT trigger (YES) or not (NO).