The VIEWS system view lists the views to which the current ident as access.
TABLE_CATALOG VARCHAR(128) The name of the catalog containing the table or view. TABLE_SCHEMA VARCHAR(128) The name of the schema containing the table or view. TABLE_NAME VARCHAR(128) The name of the table or view. VIEW_DEFINITION VARCHAR(2000) The definition of the view as it would appear in a CREATE VIEW statement. If the actual definition would not fit into the maximum length of this column, the NULL value will be shown. CHECK_OPTION VARCHAR(20) The value "CASCADED" is shown if WITH CHECK OPTION was specified in the CREATE VIEW statement that created the view, and the value "NONE" is shown otherwise. IS_UPDATABLE VARCHAR(3) One of:
"YES" = the view is updatable
"NO" = the view is not updatable.
Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40