Which SQL command should you use to delete the Storehouse field from the Item table?
A) ALTER TABLE Item DELETE Storehouse ;
B) ALTER TABLE Item DROP COLUMN Storehouse ;
C) ALTER Item DELETE Storehouse ;
D) ALTER TABLE DELETE Storehouse ;

Question

Quizplus · Accepted Answer

To delete a column from an existing table, we use the ALTER TABLE statement with the DROP COLUMN keyword. Therefore, the correct syntax is "ALTER TABLE Item DROP COLUMN Storehouse ;"

Which SQL Command Should You Use to Delete the Storehouse