B.9 Content of SQL_VIEWS

SQL_VIEWS stores viewed table definition information. Each row stores information for one viewed table.

The following table describes the content of SQL_VIEWS.

Table B‒11: Content of SQL_VIEWS
No.	Column name	Data type	Stored information
1	`TABLE_SCHEMA`	`VARCHAR(100)`	Schema name
2	`TABLE_NAME`	`VARCHAR(100)`	Table identifier
3	`VIEW_ID`	`SMALLINT`	View ID
4	`IS_UPDATABLE`	`CHAR(1)`	Updatability of viewed table `'Y'`: Updatable viewed table `'N'`: Read-only viewed table
5	`VIEW_OBJECT_SIZE`	`SMALLINT`	View object size
6	`DEFINE_SOURCE_ID`	`INTEGER`	SQL statement ID
7	`IS_INVALID`	`CHAR(1)`	Information on whether a viewed table has been invalidated `Y` Viewed table is invalidated The null value is stored if the viewed table is not invalidated.
8	`VIEW_LEVEL`	`SMALLINT`	View level