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 -
- ALTER TABLE DROP CONSTRAINT constraint_name;
- ALTER TABLE table_name DROP CONSTRAINT;
- ALTER TABLE table_name DROP CONSTRAINT constraint_name;
- 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;