EXA_DBA_VIRTUAL_COLUMNS

This system table lists all columns of virtual tables. It contains the information which are specific to virtual columns. Only users with the SELECT ANY DICTIONARY system privilege have access to the table.

Virtual columns are also listed in the table EXA_DBA_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 column object
ADAPTER_NOTES The adapter can store additional information about the virtual column in this field