SQL command used to add a new column in an existing table is :
2022
SQL command used to add a new column in an existing table is :
- A.
ALTER
- B.
UPDATE
- C.
CHANGE
- D.
ADD NEW
Attempted by 1276 students.
Show answer & explanation
Correct answer: A
To add a new column to an existing table in SQL, the ALTER command is used. The syntax is: ALTER TABLE table_name ADD column_name data_type; This command modifies the table structure by adding a new column. The UPDATE command is used to modify existing data, not to change the table structure. The CHANGE command is not a standard SQL command for adding columns. The ADD NEW command is not valid syntax in SQL. Therefore, the correct command is ALTER.