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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-09-05 : 09:42:14
|
| Chi writes "How do I change the value of a primary key? The primary key is a foreign key in another table. I was tempted to temporarily remove the realtionships and constraints, change the value of the field, and then set the constraints and relationships back again. Is there a way to change the value with out doing any of that? I have tried using the IDENTITY_INSERT property but it didn't work because because my table did not have an identity property. Any help would be much appreciated.ThanksChi" |
|
|
|
|
|
Changing the value of a primary key