Show TOC

Object documentationVIEWTABLES

 

The system table DOMAIN.VIEWTABLES contains the names of the underlying tables for all view tables for which the current user has privileges.

Structure

VIEWTABLES

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

TABLESCHEMANAME

CHAR(32)

Name of the schema of the table

TABLENAME

CHAR(32)

Name of the table

More Information

VIEWDEFS, VIEWCOLUMNS, VIEWS

SQL Reference Manual, CREATE VIEW Statement (create_view_statement)