Show TOC

Object documentationVIEWCOLUMNS Locate this document in the navigation structure

 

The system table DOMAIN.VIEWCOLUMNS contains all the columns of the view tables for which the current user has privileges.

Structure

VIEWCOLUMNS

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

VIEWCOLUMNNAME

CHAR(32)

Name of the column of the view table

TABLESCHEMANAME

CHAR(32)

Name of the schema of the table to which the used column belongs

TABLEOWNER

CHAR(32)

Name of the owner of the table to which the used column belongs

TABLENAME

CHAR(32)

Name of the table to which the used column belongs

COLUMNNAME

CHAR(32)

Name that the column originally had in the table

CREATEDATE

DATE(10)

Creation date of the view table

CREATETIME

TIME(8)

Creation time of the view table

More Information

VIEWDEFS, VIEWS, VIEWTABLES

Evaluating System Tables, VIEWCOLUMNS

SQL Reference Manual, CREATE VIEW Statement (create_view_statement)