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. |
