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

Syntax:-

ALTER TABLE table_name

DROP CONSTRAINT constraint_name

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

Suggest An Answer

No suggestions avaliable!