Computer Science for IGCSE & O level - Databases (Section 4 - No. 5)
Which SQL statement is used to add a new column to a table?
MODIFY COLUMN
ALTER TABLE ... ADD COLUMN
ADD COLUMN
UPDATE TABLE ... ADD COLUMN
Explicació
The ALTER TABLE ... ADD COLUMN statement is used to add a new column.