A virtual column contains values that are calculated using the data of other columns. The data of the virtual column is not stored in the database.
For example, to have a column that would contain data from both
last_name columns, create a virtual column with the following expression:
first_name || '.' || last.name.
The virtual column with your expression result will appear in the table, and it will also be available in the Database tool window as a virtual object.
For the table column icons, refer to Possible icon combinations for columns.
Create a virtual column
In the Database tool window ( ), expand the data source tree until the nodes of tables.
Right-click a table and select.
In the Modify dialog that opens, enter the name of your virtual column in the Name field.
Type your expression in the Expression field.