In order to add a new column to an existing table in SQL, which command is used?
2022
In order to add a new column to an existing table in SQL, which command is used?
- A.
MODIFY TABLE
- B.
EDIT TABLE
- C.
ALTER TABLE
- D.
ALTER COLUMNS
Attempted by 2195 students.
Show answer & explanation
Correct answer: C
The ALTER TABLE command is used to add, delete, or modify columns in an existing SQL table.
A video solution is available for this question — log in and enroll to watch it.