VIEWS

Definition

The system table VIEWS contains all the view tables for which the current user has privileges.

Structure

VIEWS

SCHEMANAME

CHAR(32)

Name of the schema of the view table

OWNER

CHAR(32)

Name of the owner of the view table

VIEWNAME

CHAR(32)

Name of the view table

PRIVILEGES

CHAR(30)

Privileges of the user for the view table

TYPE

CHAR(8)

Type of table

CREATEDATE

DATE(10)

Creation date of the view table

CREATETIME

TIME(8)

Creation time of the view table

UPDSTATDATE

DATE(10)

Date of the last UPDATE STATISTICS statement executed for the view table

UPDSTATTIME

TIME(8)

Time of the last UPDATE STATISTICS statement executed for the view table

ALTERDATE

DATE(10)

Date on which the view table was changed

ALTERTIME

TIME(8)

Time at which the view table was changed

UNLOADED

CHAR(3)

View table is unloaded (YES | NO)

WITHCHECKOPTION

CHAR(3)

Indicates whether the view table was created WITH CHECK OPTION or not (YES | NO)

COMPLEX

CHAR(3)

Indicates whether the view table is a complex view table or not (YES | NO)

COMMENT

LONG

Comment on the view table

See also:

Evaluating System Tables, VIEWS

VIEWDEFS, VIEWCOLUMNS, VIEWTABLES

SQL Reference Manual, CREATE VIEW Statement (create_view_statement)