A Gentle Introduction to
CREATE and DROP
How to create tables, indexes, views and other things. How to get rid of them.
how can i delete a column from a table ?
how can a full column can be removed from an existing table, where the column contains data?
DROP TABLE a; CREATE TABLE a(x INTEGER, y INTEGER); INSERT INTO a VALUES (1,2); ALTER TABLE a DROP COLUMN y