​Structure of the ORDERITEMS Table

Multiple Choice

​Structure of the ORDERITEMS table

-If a PRIMARY KEY constraint,named ORDERITEMS_PK,exists for the ORDER# and ITEM# columns of the ORDERITEMS table,which of the following commands will drop the constraint?​

A) ALTER TABLE orderitems
DROP PRIMARY KEY CONSTRAINT;
B) ALTER TABLE orderitems
DELETE CONSTRAINT orderitems_pk;
C) ALTER TABLE orderitems
DROP PRIMARY KEY;
D) ​ALTER TABLE orderitems
MODIFY PRIMARY KEY CONSTRAINT DROP;