更改后删除规则没有动作到我的表中级联然后保存表FK关系自动Destryod [英] After change Delete Rule no Action to Cascade in My Table then save table FK Relationship Has Destryod automatically

问题描述

在保存过程中输入了错误，某些数据对象未保存，





我正在进行的项目中有一些严重问题



i想在我的数据库表中更改（Sql2008R2）



我正在尝试更改关键关系



一旦我完成更改，我的表关系约束已自动销毁



步骤我在这里解释一下



打开桌子设计视图



打开关系



转到RelationShip和ChangeInsert更新规则您可以注意到，在底部弹出窗口

更改删除规则否行动到级联/>


然后在我要保存之后如果我选择OK Ok Tab然后我的另一个关系船包含自动销毁..



Plzzzz帮我解决它发生在我正在进行的Projecr

Error was encored during save process some data object were not saved,


I have some serious issue in my ongoing project

i want to change in my db table(Sql2008R2)

I am trying to change in Key Relationship

Once I go through the change my table Relationship Constraint has destroyed Automatically

Step I explain you Here

Open Table Desing View

Open Relationship

Go to RelationShip and ChangeInsert Update Rule You can Notice that at bottom og pop up
Change Delete Rule No Action To Cascade

then After I am going to save if I select OK Ok Tab then my other relation ship contains Destroyed Automatically..

Plzzzz Help me out Its happen in My ongoing Projecr

推荐答案

最好的选择wo你可以放弃整个桌子并重新创建它。我至少会这样做。如果表包含数据，则将其放在临时表中，甚至是excel（比对不起更安全）。现在使用新的PK-FK关系重新创建表。更好地编写脚本来执行这些操作而不是使用设计视图。我一直觉得它更麻烦而不是有用的东西。无论如何，这是我的观点。

The best option would be to drop the whole table and recreate it again. I would at least do that. If the table contains data put it in a temp table or even an excel(better safe than sorry). Now recreate the table with the new PK-FK Relationship. Better write scripts to do these things instead of using the design view. I have always found it to be more of a hassle than a useful thing. Anyway that was my point of view.

这篇关于更改后删除规则没有动作到我的表中级联然后保存表FK关系自动Destryod的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！