EXA_USER_VIRTUAL_COLUMNS

The system table lists all columns of virtual tables owned by the current user. It contains the information which are specific to virtual columns. All users have access to the table.

Virtual columns are also listed in the table EXA_USER_COLUMNS.

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