If you need to add a new column named Email to an existing table called Users,…
2026
If you need to add a new column named Email to an existing table called Users, which statement would you use?
- A.
UPDATE Users ADD Email VARCHAR(50);
- B.
ALTER TABLE Users ADD Email VARCHAR(50);
- C.
ALTER Users INSERT Email VARCHAR(50);
- D.
UPDATE TABLE Users ADD Email VARCHAR(50);
Attempted by 332 students.
Show answer & explanation
Correct answer: B
To add a new column to an existing table, use the ALTER TABLE statement. The correct syntax is ALTER TABLE table_name ADD column_name data_type; For instance, adding an Email column to the Users table requires: ALTER TABLE Users ADD Email VARCHAR(50);