SQL Server底层成员UpdateAction和DeleteAction的外键位值

huangapple go评论71阅读模式
英文:

Foreign key Bit values of SQL Server underlying members UpdateAction and DeleteAction

问题

有人知道我在哪里可以找到关于SqlServer的ForeignKey底层成员UpdateAction和DeleteAction的位值的文档吗?

它们的类型是Int32,但我很难找到有关每个位如何等同于No Action、Cascade、Set Null等的文档。

我必须提供从Firebird的值转换而来的每个映射整数值,以在Visual Studio的IDSRefBuilder AppendToDSRef拖放服务中使用。

英文:

Does anyone know where I can find documentation on the bit values for SqlServer's ForeignKey underlying members UpdateAction and DeleteAction.

They are type Int32 but I am struggling to find any documentation on how the bits in each equate to No Action, Cascade, Set Null etc.

I have to provide the mapped integer values of each converted from Firebird's values to use in the Visual Studio IDSRefBuilder AppendToDSRef drag and drop service.

答案1

得分: 1

是的,感谢 @Larnu。
正是我所寻找的。它是 sys.foreign_keys 下的 delete_referential_action 和 update_referential_action。

英文:

Yeah thanks @Larnu.
Exactly what I was looking for.</br>It's delete_referential_action and update_referential_action under sys.foreign_keys.

huangapple
  • 本文由 发表于 2023年2月27日 04:03:43
  • 转载请务必保留本文链接:https://go.coder-hub.com/75574700.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定