ADD COLUMNS

Syntax

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