Wednesday, October 28, 2009

Disable a constraint in a table(ORACLE)

The following statement can be used to disable a constraint in a table

ALTER TABLE_NAME MODIFY CONSTRAINT CONSTRAINT_NAME DISABLE


EX:
 ALTER TABLE EMPLOYEE CONSTRAINT SYS_FK1 DISABLE

No comments:

Powered By Blogger