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

Question

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

Quizplus · Accepted Answer

The correct SQL command for deleting a column from a table is "ALTER TABLE [table_name] DROP COLUMN [column_name]". Therefore, the correct SQL command for deleting the Storehouse field from the Item table is "ALTER TABLE Item DROP COLUMN Storehouse". A is incorrect because "DELETE" is not used in the syntax for dropping a column. C is incorrect because "ALTER" must be followed by "TABLE" to specify that the changes are being made to a table. D is incorrect because "ALTER TABLE" is necessary to identify the table that is being modified.

The SQL Command for Deleting the Storehouse Field from the Item