Virtual columns
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 first_name and 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.
Virtual columns can be seen in the Database tool window. You can see a reference on node and object icons in the Icons for data sources and their elements chapter of Database window topic.
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.
Click OK.
