c# – 如何更新另一个表中作为外键引用的表的主键？

发布时间：2020-12-15 19:43:07 所属栏目：百科来源：网络整理

导读：假设一个 Table "Person" having "SSN","Name","Address" 和另一个 Table "Contacts" having "Contact_ID","Contact_Type","SSN" (primary key of Person) 同样 Table "Records" having "Record_ID","Record_Type","SSN" (primary key of Person) 现在我希望

假设一个

Table "Person" having 
    "SSN","Name","Address"

和另一个

Table "Contacts" having
    "Contact_ID","Contact_Type","SSN" (primary key of Person)

同样

Table "Records" having
    "Record_ID","Record_Type","SSN" (primary key of Person)

现在我希望当我更改或更新SSN in person表时,相应地在其他2个表中更改.

>如果有人可以帮我解决这个问题
>或者如何为表传递外键约束

解决方法

只需将ON UPDATE CASCADE添加到外键约束即可.

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!