Correct syntax The query syntax for removing a column from a table is as follows:
A. DELETE COLUMN column name;
B. DROP COLUMN column name;
C. ALTER TABLE table name DROP COLUMN column name;
D. None of the options are correct.
Answer:C
Correct syntax The query syntax for removing a column from a table is as follows:
A. DELETE COLUMN column name; B. DROP COLUMN column name; C. ALTER TABLE table name DROP COLUMN column name; D. None of the options are correct.
Explanation: To remove a column from an existing table, the initial table should be updated with the ALTER TABLE statement.