how to disable foreign key constraints
Posted on 2007-03-22
I have two tables TEST_TABLE and TEST_TABLE_02. TEST_TABLE_02 having some foreign key constraints to TEST_TABLE. I want to drop TEST_TABLE because I want to make an int field an IDENTITY field. When I issue DROP TABLE TEST_TABLE, I get the following error
Could not drop object 'TEST_TABLE' because it is referenced by a FOREIGN KEY constraint.
I know I have to drop the constraints on the TEST_TABLE_02 for instane foreign key constraint but for some reason I do not want to do it.
Is it possible to disable constraints for a time being and later enable 'em.
Thanks in advance