ALTER TABLE ... DROP COLUMN
Delete a column from a table
This is in the SQL standard ALTER TABLE
DROP TABLE a
CREATE TABLE a(x INTEGER, y INTEGER); INSERT INTO a VALUES (1,2);
ALTER TABLE a DROP COLUMN y; SELECT * FROM a;
ALTER TABLE a DROP y; SELECT * FROM a;
ALTER TABLE documentation.]
DB2 seemingly does not permit this operation - any help would be appreciated.
Sybase doesn't like the COLUMN keyword.