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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment