alter TABLE {name} [[rename to {new name}], [add column {column}]]

ALTER TABLE demo RENAME TO demo_new

-- rename table

ALTER TABLE demo RENAME COLUMN hint TO info

-- rename column

-- add new column and remove column:

CREATE TABLE _tmp (id integer primary key, 

                   name VARCHAR(20), 

                   tag INTEGER NOT NULL DEFAULT 0, 

                   newtime TIMESTAMP DEFAULT CURRENT_TIMESTAMP);

-- create new table 

INSERT INTO _tmp(name) SELECT name FROM demo;

-- move data

DROP TABLE demo;

-- remove old table

ALTER TABLE _tmp RENAME TO demo;

-- rename new table