VIEWCOLUMNS
The system table DOMAIN.VIEWCOLUMNS
contains
all the columns of the view tables for which the current user has privileges.
|
CHAR(32) |
Name of the schema of the view table |
|
CHAR(32) |
Name of the owner of the view table |
|
CHAR(32) |
Name of the view table |
|
CHAR(32) |
Name of the column of the view table |
|
CHAR(32) |
Name of the schema of the table to which the used column belongs |
|
CHAR(32) |
Name of the owner of the table to which the used column belongs |
|
CHAR(32) |
Name of the table to which the used column belongs |
|
CHAR(32) |
Name that the column originally had in the table |
|
DATE(10) |
Creation date of the view table |
|
TIME(8) |
Creation time of the view table |
Evaluating System Tables, VIEWCOLUMNS
SQL Reference Manual, CREATE VIEW Statement (create_view_statement)