how to modify primary key in oracle code example
Example 1: add primary key constraint in oracle
-- Adding Using alter
ALTER TABLE table_name
ADD CONSTRAINT constraint_name PRIMARY KEY (column1, column2, ... column_n);
Example 2: drop primary key oracle
-- Dropping Using alter
ALTER TABLE table_name
DROP CONSTRAINT constraint_name;