database: mssql

[tho]

I am conducting a database design and I managed to reach the 3rd normal form. My question is, if i change my primary key, for example '0001' to '0002', is it possible to propagate the change/update to the other linked table.

if you require more info, please let me know. Thank you in advance.

 

[tho]

anyone?

 

[NuclearNed]

I don't know, but the following MS forum might be a good place to look for answers:

TSQL forum

 

[kamper]

Off the top of my head, would putting "ON UPDATE CASCADE" in the definition of the foreign key do what you're looking for?