add primary key constraint in oracle
snippet in sql

add primary key constraint in oracle

user795

-- Adding Using alter
ALTER TABLE table_name
ADD CONSTRAINT constraint_name PRIMARY KEY (column1, column2, ... column_n);

drop primary key oracle

user4084

-- Dropping Using alter
ALTER TABLE table_name
DROP CONSTRAINT constraint_name;