This system table lists all views in the database. Only users with the SELECT ANY DICTIONARY system privilege have access to the table.

Column Name Description
VIEW_SCHEMA Name of the schema in which the view was created
VIEW_NAME Name of the view
SCOPE_SCHEMA Schema that was explicitly opened by means of a connection parameter or OPEN SCHEMA command before view creation
VIEW_OWNER Owner of the view
VIEW_OBJECT_ID Internal ID of the view
VIEW_TEXT Text of the view, with which it was created
VIEW_COMMENT Comment on the view