Mimer SQL Reference Manual TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


VIEWS


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.

Column name
Data type
Description
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
dbtechnology@upright.se
Mimer SQL Reference Manual TOC PREV NEXT INDEX