Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Cascade update

Author  Topic 

Bilal123456
Starting Member

1 Post

Posted - 2013-08-15 : 04:42:27
I need to find a list of all relations in my database that do not have an "on update cascade".
Is there a query for that?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2013-08-15 : 06:37:57
Yes.



Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2013-08-15 : 06:39:29
Here is a start.
SELECT	*
FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS;



Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA
Go to Top of Page

djj55
Constraint Violating Yak Guru

352 Posts

Posted - 2013-08-15 : 08:39:26
also have a look at sys.foreign_keys

djj
Go to Top of Page
   

- Advertisement -