Skip to content

Latest commit

 

History

History
24 lines (15 loc) · 457 Bytes

COLUMN.md

File metadata and controls

24 lines (15 loc) · 457 Bytes

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