Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Linok
Starting Member
34 Posts |
 Posted - 2007-07-17 : 11:25:38
|
| Hey everyone,I have 3 tables I need to change. I need to change the PK of the parent table and the FKs of the parent tables. They're all GUIDs. I've tried doing it manually, but the constraints keep me from updating anything. Is there an easy to quickly disable the constraints, do the update, and re-enable them?Thanks in advance! |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-07-17 : 11:59:12
|
| You can disable/enable constraints. Check books on line for "Constraints" to see how to do that.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
Linok
Starting Member
34 Posts |
Posted - 2007-07-17 : 12:37:02
|
| Awesome. Thanks |
|
|
|
|
|
|
Changes the PKs and FKs of tables