Drop constraint is used for removing the constraints from the table.

Syntax:-

ALTER TABLE table_name

DROP CONSTRAINT constraint_name

BY Best Interview Question ON 19 Feb 2019

Example

For example:- if the table name is INTERVIEW. QUESTIONS and the constraint name is TEST_ CONST

ALTER TABLE INTERVIEW. QUESTIONS
DROP CONSTRAINT TEST_ CONST