英文:
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.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论