From Eigenpedia

NOTE: This feature is currently only available in the 0.8.1 prerelease.

Syntax

ALTER TABLE qualified-table-name ADD [ COLUMN ] column-definition

column-definition ::= 
unqualified-column-name
data-type
[ DEFAULT default-value-literal | identity-column-specification ]
[ NOT NULL ]

See LucidDbCreateTable for specification of column-definition, except that including a constraint-definition on the new column is not yet supported by ALTER TABLE ADD COLUMN.

Example

ALTER TABLE warehouse.employee_dimension ADD COLUMN salary NUMERIC(7,2) DEFAULT 30000.02 NOT NULL;