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

46 views Asked by At

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

There are 1 answers

0
Greg C On

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