EXA_ALL_VIRTUAL_COLUMNS

The system table lists all columns of virtual tables to which the current user has access. It contains the information which are specific to virtual columns. Virtual columns are also listed in the table EXA_ALL_COLUMNS. All users have access to the table.

Column Name Description
COLUMN_SCHEMA Associated virtual schema
COLUMN_TABLE Associated virtual table
COLUMN_NAME Name of the virtual column
COLUMN_OBJECT_ID ID of the virtual columns object
ADAPTER_NOTES The adapter can store additional information about the virtual column in this field