August 18, 2009 at 1:32 pm
I have a column (which happens to be a Primary Key). It has FK relationships in various other tables.
I need to update that PK column but don't know how to do so. I don't remember ever doing this in the past, but I have need to do so now.
I read that you can set up the constraint for ON UPDATE CASCADE, but that isn't in place.
August 18, 2009 at 2:19 pm
You'll either need to modify the FK constraints so they cascade, or you'll need to disable them during the update and update each table individually and then re-enable them.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
August 18, 2009 at 2:24 pm
Thank you. That is what I was thinking.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply