Programatically Identify All Foreign Keys that Cascade

Question

I need to use SQL to identify all foreign keys that have a cascading delete. Can someone tell me where I can find out whether a foreign key is cascading?

Thanks!

Answer 1

you can look in informatation_schema

select * from INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS
where DELETE_RULE = 'CASCADE' OR UPDATE_RULE = 'CASCADE'

Answer 2

SELECT * FROM sys.foreign_keys 
  WHERE delete_referential_action > 0
     OR update_referential_action > 0;