Skip to content

Alter Table

agershun edited this page Dec 28, 2014 · 3 revisions

ALTER TABLE

ADD COLUMN

    alasql('ALTER TABLE City ADD COLUMN Continent STRING');

RENAME COLUMN

    alasql('ALTER TABLE City RENAME COLUMN Continent TO WorldPart');

DROP COLUMN

    alasql('ALTER TABLE City DROP COLUMN Continent');

RENAME TO

   alasql('ALTER TABLE City RENAME TO Capital');
Clone this wiki locally