Question $2(4$ points$)$

Working with a PART table that has columns PART$\_$CODE, PART$\_$DESCRIPT, PART$\_$PRICE, and VENDOR$\_$CODE, how would a user drop the vendor information from the table?

ALTER TABLE PART DROP COLUMN VENDOR$\_$CODE;

MODIFY TABLE PART DELETE COLUMN VENDOR$\_$CODE;

MODIFY TABLE PART DELETE VENDOR$\_$CODE;

CHANGE TABLE PART DROP COLUMN VENDOR$\_$CODE;