# 37.66. views The view `views` contains all views defined in the current database. Only those views are shown that the current user has access to (by way of being the owner or having some privilege). #### **Table 37.64. `views` Columns** |

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