Please explain drop constraint Oracle?

1.	Please explain drop constraint Oracle?
Answer» 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

Answer»

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

Discussion