Skip to content
Mathias Rangel Wulff edited this page Nov 24, 2015 · 5 revisions

Keyword COLUMN

Syntax:

    -- Result modifier for a `SELECT`  
    COLUMN OF SELECT ...
    SELECT COLUMN ...

    -- Normal SQL
    ALTER TABLE table ADD COLUMN column type
    SELECT * REMOVE COLUMN (column | LIKE mask)

You can set query modifier for all SELECTs:

    alasql.options.modifier = 'COLUMN';

See also: [ADD COLUMN](Add Column), [REMOVE COLUMN](Remove Column), RECORDSET, VALUE, ROW

Clone this wiki locally