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?
Answer: B. ALTER TABLE Users ADD Email VARCHAR(50);
- 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 907 students.
Show answer & explanation
Correct answer: B
Loading lesson…