CODEWITHSUNDEEP
t-sql
Zéiksz
Zéiksz

Reputation: 696

Check foreign keys

I want to extend my query for delete and update rule, but I just can not figure what column in what systable that is in.

My query so far:

select oct.name FKNeve,oft.name TAmit,ofc.name MAmit,ort.name TAmihez,orc.name MAmihez
from sysforeignkeys sfk
inner join sysobjects oct on sfk.constid = oct.id
inner join sysobjects oft on sfk.fkeyid = oft.id
inner join syscolumns ofc on sfk.fkey = ofc.colid and sfk.fkeyid = ofc.id
inner join sysobjects ort on sfk.rkeyid = ort.id
inner join syscolumns orc on sfk.rkey = orc.colid and sfk.rkeyid = orc.id

Oh and MSDE.

Upvotes: 0

Views: 66

Answers (1)

Razvan Socol
Razvan Socol

Reputation: 5684

Use the OBJECTPROPERTY function (with 'CnstIsDeleteCascade'/'CnstIsUpdateCascade' as the second argument).

Upvotes: 1

Related Questions