constraints rule can be ‘RESTRICT’ OR ‘SET NULL’ OR ‘CASCADE’

SELECT
distinct table_name
FROM
information_schema .referential_constraints
WHERE
constraint_schema = ‘<DB Name>’
AND ( delete_rule = ‘RESTRICT’ OR update_rule = ‘RESTRICT’ );