VIEWS
The VIEWS view contains one row for each view.
The following table describes the columns in the view:
Column Name | Data Type | Description |
---|---|---|
TABLE_CATALOG | VARCHAR(128) | Relational database name |
TABLE_SCHEMA | VARCHAR(128) | Name of the SQL schema that contains the view. |
TABLE_NAME | VARCHAR(128) | Name of the view. |
VIEW_DEFINITION | DBCLOB(2M) CCSID 13488 Nullable |
The query expression portion of the CREATE VIEW statement. |
CHECK_OPTION | VARCHAR(8) | The check option used on the view
|
IS_UPDATABLE | VARCHAR(3) | Specifies if the view is updatable:
|