ALTER TABLE ... ADD COLUMN
Add a column to a table
This is in the SQL standard ALTER TABLE The term COLUMN is optional.
DROP TABLE a
CREATE TABLE a(x INTEGER, y INTEGER); INSERT INTO a VALUES (1,2);
ALTER TABLE a ADD COLUMN z INTEGER; SELECT * FROM a;
ALTER TABLE a ADD z INTEGER; SELECT * FROM a;
ALTER TABLE documentation. DB2 seemingly does not permit this operation - any help would be appreciated.
Sybase and SQL Server do not permit the COLUMN keyword.