Oracle ENABLE PRIMARY KEY Constraint

In Oracle, sometimes you may need to ENABLE PRIMARY KEY constraint if you disabled, you use the following ENABLE PRIMARY KEY statement.

Oracle ENABLE PRIMARY KEY Constraint example

The following Oracle, enable primary key using ENABLE PRIMARY KEY in "tblCustomer" table:

ALTER TABLE tblCustomer
ENABLE PRIMARY KEY;

OR

ALTER TABLE tblCustomer
ENABLE CONSTRAINT pk_customrer;

Note:

In the above example, we are enabling primary key in "tblCustomer" table using ENABLE PRIMARY KEY constraint.