When using the ALTER TABLE...DROP COLUMN command,which of the following is not correct?
A) The command's effect on the table is permanent.
B) You cannot delete the last remaining column in a table.
C) The command deletes both the column and its contents.
D) The command can be used to delete multiple columns from a table.

Question

When using the ALTER TABLE...DROP COLUMN command,which of the following is not correct?​
A) ​The command's effect on the table is permanent.
B) ​You cannot delete the last remaining column in a table.
C) ​The command deletes both the column and its contents.
D) ​The command can be used to delete multiple columns from a table.

Quizplus · Accepted Answer

The ALTER TABLE...DROP COLUMN command is typically used to drop a single column at a time, not multiple columns in a single command.

When Using the ALTER TABLE