Sys equivalent of query submission INFORMATION_SCHEMA

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?

+5
source share
1 answer
 SELECT * FROM sys.foreign_keys WHERE delete_referential_action = 1 
+2
source

Source: https://habr.com/ru/post/1240151/


All Articles