how to modify primary key in a table?

Navigation
0

This is the problem: I have a product table (with data) and it is related to the detail-selling table (idproduct).

Is it possible to update the primarykey of the product table even if that data is already in use in the detail-selling table?

    
asked by Javier 09.11.2017 в 02:37
source

1 answer

0

If at the time of creating the relationship you set ON UPDATE CASCADE then when you make changes, they will affect the foreigner.

reference: link

PS: you can always change these rules, from the view of the relationships in your detail table

    
answered by 09.11.2017 / 02:48
source
doubts show products Master Data Web Service