ADD COLUMNS
Syntax
Syntax
SQL
ALTER TABLE <table> ADD COLUMNS (<colName> as <formula>);<table>
The table you want to add a column into.
<colName>
The name of your chosen Column.
<formula>
The formula you want to use.
For example: CONCAT(CAST(ROUND(fval * 0.8, 2) AS STRING), '€') when fval is an existing field in the table
Output
This SQL command does not return anything