Skip to main content
Skip table of contents

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


JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.