TWIRED Posted December 15, 2016 Report Share Posted December 15, 2016 Hi if I have 2 Tables (Parent (PK) & Child (FK) ) in a relationship Is it possible to change / update the primary or foreign key ?? Normally this is how I do it in adatabase where I hvae access to everything disable enforcing PK or FK constraints temporarily update your PK update your FKs enable back enforcing PK / FK constraints Quote Link to comment Share on other sites More sharing options...
0 Mathilda Posted December 20, 2016 Report Share Posted December 20, 2016 On 12/16/2016 at 1:42 AM, TexterVaid said: Hi if I have 2 Tables (Parent (PK) & Child (FK) ) in a relationship Is it possible to change / update the primary or foreign key ?? Normally this is how I do it in adatabase where I hvae access to everything disable enforcing PK or FK constraints temporarily update your PK update your FKs enable back enforcing PK / FK constraints Hi TexterVaid, It sounds like cascade update setting in relationship. You can read more here Hope that helps TWIRED 1 Quote Link to comment Share on other sites More sharing options...
Question
TWIRED
Hi if I have 2 Tables (Parent (PK) & Child (FK) ) in a relationship
Is it possible to change / update the primary or foreign key ??
Normally this is how I do it in adatabase where I hvae access to everything
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.