| 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áš Vichta | 17 Feb |
| • Re: How to turn off all constraints in a table? | sheeri kritzer | 20 Feb |
| • Re: How to turn off all constraints in a table? | SGreen | 21 Feb |
| • Re: How to turn off all constraints in a table? | SGreen | 21 Feb |
