Home > SQL, Technical > Remove constraints for existing columns in Oracle

Remove constraints for existing columns in Oracle

July 27, 2012

Syntax: ALTER TABLE TABLE_NAME DROP CONSTRAINT CONSTRAINT_NAME

Example1: ALTER TABLE ORDERS DROP CONSTRAINT PK_NEW1;

Advertisements
Categories: SQL, Technical
%d bloggers like this: