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