​Structure of the ORDERITEMS Table

Multiple Choice

​Structure of the ORDERITEMS table

-If the constraints on the ORDER# and ITEM# columns of the ORDERITEMS table were created as a PRIMARY constraint,and the actual constraint name is not known,which of the following commands can be used to delete the constraint?​

A) ALTER TABLE orderitems
DROP ALL CONSTRAINTS;
B) ALTER TABLE orderitems
DELETE ALL CONSTRAINTS;
C) ALTER TABLE orderitems
DROP PRIMARY KEY;
D) ​ALTER TABLE orderitems
DELETE PRIMARY KEY;