​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 disable the constraint?​

A) ALTER TABLE orderitems
DISABLE PRIMARY KEY CONSTRAINT;
B) ALTER TABLE orderitems
DISABLE CONSTRAINT orderitems_pk;
C) ALTER TABLE orderitems
REMOVE PRIMARY KEY CONSTRAINT;
D) ​ALTER TABLE orderitems
MODIFY PRIMARY KEY CONSTRAINT DISABLE;