Drop constraint key

To drop constraint key on a table of Oracle database you must use the alter table command.

Syntax

ALTER TABLE table_name
DROP CONSTRAINT constraint_name;

Drop constraint key example

  
ALTER TABLE test 
DROP CONSTRAINT pk_test_id;

Output:

table TEST altered.