Oracle PRIMARY KEY Delete, federated primary key creation

1. Delete the primary key ALTER table TABLENAME drop primary_key Run the above SQL to remove the primary key; Assuming that the ALTER TABLE TABLENAME drop CONSTRAINTS COLUMN Cascad is not successful E --delete constraint alter TABLE TABLENAME DISABLE Primary_column; --Set the column that is set as the primary key invalid drop INDEX index_name; --Delete primary key index
2, view PRIMARY KEY constraint select * from user_constraints WHERE constraint_type= ' P ' and table_name= ' the table name you want to view ' and Owner=user
3. Create a federated primary key alter TABLE ADD CONSTRAINTS ' constraint name ' PRIMARY KEY (Column,column,...);

Oracle PRIMARY KEY Delete, federated primary key creation