SYSVIEWS catalog table

The SYSVIEWS table contains one or more rows for each view, materialized query table, or user-defined SQL function. The schema is SYSIBM.

Column name Data type Description Use
NAME
VARCHAR(128)
NOT NULL
 Name of the object. G
CREATOR
VARCHAR(128)
NOT NULL
 The schema of the object. G
SEQNO
SMALLINT
NOT NULL
 Not used. N
CHECK
CHAR(1)
NOT NULL
 Whether the WITH CHECK OPTION clause was specified in the CREATE VIEW statement:
N
No
C
Yes with the cascaded semantic
Y
Yes with the local semantic
The value is N if the view has no WHERE clause, or the object is not a view.		 G
IBMREQD
CHAR(1)
NOT NULL
 A value of Y indicates that the row was provided with the Db2 product code. For all other values, see Release dependency indicators.

The value in this field is not a reliable indicator of release dependencies. RELCREATED should be used instead.

 G
TEXT
VARCHAR(1500)
NOT NULL
 Not used. N
PATHSCHEMAS
VARCHAR(2048)
NOT NULL WITH
DEFAULT
 SQL path at the time the object was defined. The path is used to resolve unqualified data type and function names used in the object definition. G
RELCREATED
CHAR(1)
NOT NULL
 The release of Db2 that is used to create the object. Blank if created prior to Version 9. See Release dependency indicators for all other values. G
TYPE
CHAR(1)
NOT NULL
 Type of table:
F
SQL function
M
Materialized query table
V
View
 G
REFRESH
CHAR(1)
NOT NULL WITH
DEFAULT
 Refresh mode:
D
A materialized query table with a deferred refresh mode
blank
Not a materialized query table
 G
ENABLE
CHAR(1)
NOT NULL WITH
DEFAULT
 Indicates whether query optimization is enabled:
Y
Enabled
N
Disabled
blank
Not a materialized query table
 G
MAINTENANCE
CHAR(1)
NOT NULL WITH
DEFAULT
 Maintenance mode:
S
For a REFRESH = 'D', a materialized query table that is maintained by the system.
U
For a REFRESH = 'D', a materialized query table that is maintained by the user.
blank
Not a materialized query table.
 G
REFRESH_TIME
TIMESTAMP
NOT NULL WITH
DEFAULT
 For REFRESH = 'D' and MAINTENANCE = 'S', the timestamp of the REFRESH TABLE statement that last refreshed the data. Otherwise, this is the default timestamp ('0001-01-01.00.00.00.000000'). G
ISOLATION
CHAR(1)
NOT NULL WITH
DEFAULT
 Isolation level when the materialized query table is created or altered from a base table:
R
RR (repeatable read)
S
CS (cursor stability)
T
RS (read stability)
U
UR (uncommitted read)
blank
Not a materialized query table
 G
SIGNATURE
VARCHAR(1024)
NOT NULL WITH
DEFAULT
FOR BIT DATA
 Contains an internal description. Used for materialized query tables. G
APP_ENCODING_
CCSID
INTEGER
NOT NULL WITH
DEFAULT
 CCSID of the current application encoding scheme at the time the object was created. For objects created prior to Version 8 of Db2, the value is 0. G
OWNER
VARCHAR(128)
NOT NULL WITH
DEFAULT
 Authorization ID of the owner of the view, blank for views that were created in a Db2 release prior to Version 9. G
OWNERTYPE
CHAR(1)
NOT NULL WITH
DEFAULT
 Indicates the type of owner:
blank
Authorization ID
L
Role
 G
ENVID
INTEGER
NOT NULL
WITH DEFAULT
 Internal environment identifier. G
ROWID
ROWID
NULL
GENERATED
ALWAYS
 ROWID column, created for the lob columns in this table G
STATEMENT
CLOB(2M)
NOT NULL
WITH DEFAULT
 The text of the statement that created the view. In some cases, this column might instead contain the text of a statement that altered the view. In many cases, changes to views or to objects on which views are dependent do not update this value. G
—
BLOB(1G)
NOT NULL
WITH DEFAULT
 Internal use only. I