Thursday, November 17, 2011

Oracle add or drop primary key

ALTER TABLE supplier
add CONSTRAINT supplier_pk PRIMARY KEY (supplier_id);

ALTER TABLE supplier
drop CONSTRAINT supplier_pk;

No comments:

Blog Archive