asked on Update Sql Server tables with Foreign Key constraints
Greetings, I need to update multiple tables where userid = bob to userid = bob.smith.
But I'm getting foreign key constraint errors. How can I fix the DB so I can fix this so I can update all dependant tables. Thank you.
But I'm getting foreign key constraint errors. How can I fix the DB so I can fix this so I can update all dependant tables. Thank you.
Microsoft SQL Server 2005Microsoft SQL Server
Last Comment
centem
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
IJZ, thanks that worked. How do I return the constraints so that nothing breaks.