The SQL command for deleting the Warehouse field from the Part table is ____.
A)ALTER TABLE Part DROP COLUMN Warehouse ;
B)ALTER Part DROP Warehouse ;
C)ALTER Part DELETE Warehouse ;
D)ALTER TABLE DELETE Warehouse ;

Question

Quizplus · Accepted Answer

The correct SQL command for deleting the Warehouse field from the Part table is "ALTER TABLE Part DROP COLUMN Warehouse". Option A is the only choice that uses the correct syntax for removing a column from a table. Options B, C, and D use incorrect syntax and are not valid SQL commands.

The SQL Command for Deleting the Warehouse Field from the Part