Sambi Writes...
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:
Post a Comment
‹
›
Home
View web version
No comments:
Post a Comment