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 |