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

Explanation

The ALTER TABLE ... ADD COLUMN statement is used to add a new column.

Comments (0)

Advertisement