ALTER TABLE ... ADD COLUMN

From SQLZoo
Jump to navigation Jump to search

Add a column to a table

schema:scott

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;
DataWars, Data Science Practice Projects - LogoDataWars: Practice Data Science/Analysis with +100 Real Life Projects