Home » MCQs » Oracle MCQs » Oracle Change Password, Check Constraints, Comments, and Primary Key MCQs

Syntax to Drop Primary Key is –

13. Syntax to Drop Primary Key is -

1. ALTER TABLE DROP CONSTRAINT constraint_name;
2. ALTER TABLE table_name DROP CONSTRAINT;
3. ALTER TABLE table_name DROP CONSTRAINT constraint_name;
4. ALTER TABLE DROP CONSTRAINT;

Answer: C) ALTER TABLE table_name DROP CONSTRAINT constraint_name;

Explanation:

Syntax to Drop Primary Key is:

ALTER TABLE table_name DROP CONSTRAINT constraint_name;