List:General Discussion« Previous MessageNext Message »
From:Tomáš Vichta Date:February 17 2006 10:27am
Subject:How to turn off all constraints in a table?
View as plain text  
Hello,
I need to turn off all constraints in a table (especially primary and 
foreign keys) - because for example I need to exchange primary key 
values of two rows in a table. And because of primary key constraints I 
can do it directly. I would to turn off the constraint, rename value of 
PK1 to PK2 - now I have the same 2 values PK2 and it's the problem, if 
the primary key constraint is enabled.

Thanx very much for answer, TV.
Thread
How to turn off all constraints in a table?Tomáš Vichta17 Feb
  • Re: How to turn off all constraints in a table?sheeri kritzer20 Feb
    • Re: How to turn off all constraints in a table?SGreen21 Feb
Re: How to turn off all constraints in a table?SGreen21 Feb