-Find Table have Delete CaseCade have or not

Jayakumars
Posted by Jayakumars under SQL Server category on | Points: 40 | Views : 629
10.--Find Table have Delete CaseCade have or not--
Select * FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS where DELETE_RULE='CASCADE'
Select * FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS where DELETE_RULE<>'CASCADE'

Comments or Responses

Login to post response