I wanted to get a list of all cascading deletes in my database, so I used the INFORMATION_SCHEMA view:
SELECT * FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS WHERE DELETE_RULE = 'CASCADE'
What is the equivalent of this query using sys system views?
source share