The VIEWS system view lists the viewed tables on which the current ident, or PUBLIC, holds one or more privileges (INSERT, DELETE or SELECT; or REFERENCES or UPDATE on one or more columns).
The views listed in this system view also appear in the TABLES system view.
TABLE_CAT VARCHAR(128) The name of the catalog containing the table or view. TABLE_SCHEM 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.
REMARKS VARCHAR(254) May contain descriptive information about the view.
Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40