Column Type
Description
table_catalog sql_identifier
Name of the database that contains the view (always the current database)
table_schema sql_identifier
Name of the schema that contains the view
table_name sql_identifier
Name of the view
view_definition character_data
Query expression defining the view (null if the view is not owned by a currently enabled role)
check_option character_data
CASCADED or LOCAL if the view has a CHECK OPTION defined on it, NONE if not
is_updatable yes_or_no
YES if the view is updatable (allows UPDATE and DELETE), NO if not
is_insertable_into yes_or_no
YES if the view is insertable into (allows INSERT), NO if not
is_trigger_updatable yes_or_no
YES if the view has an INSTEAD OF UPDATE trigger defined on it, NO if not
is_trigger_deletable yes_or_no
YES if the view has an INSTEAD OF DELETE trigger defined on it, NO if not
is_trigger_insertable_into yes_or_no
YES if the view has an INSTEAD OF INSERT trigger defined on it, NO if not