ADD COLUMNS ​

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