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 |