SQL Reference
ALTER
Add and drop columns and attributes; pause and resume transforms.
ALTER TABLE — columns
ALTER TABLE a ADD COLUMN extra Int64;
ALTER TABLE a DROP COLUMN sym;
ALTER TABLE accounts ADD COLUMN note String DEFAULT 'x';
ALTER TABLE audit ADD COLUMN level String DEFAULT 'info';ADD COLUMN takes exactly one column definition per statement.
ALTER TABLE — attributes
On attribute tables, add or drop attributes:
ALTER TABLE acct ADD ATTRIBUTE score UInt64;ADD ATTRIBUTE / DROP ATTRIBUTE require an attribute table (one declared with
an ATTRIBUTE (…) clause). Applying them to a plain table is an error.
ALTER TRANSFORM
ALTER TRANSFORM t_a PAUSE;
ALTER TRANSFORM t_a RESUME;See CREATE TRANSFORM for the lifecycle.