Showing posts with label alter. Show all posts
Showing posts with label alter. Show all posts

Friday, March 23, 2012

Query for setting Cascade on Update in table relationships

Hi,

I'm looking for a query I can use to alter table relationships. What I want to do in particular, is to set every relationship to cascade on update. Can anyone point me out to a solution? MSDN seems very vague in this subject.

Thanks,
Tiago

Write queries to drop the constraints and recreate them with the appropiate settings.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

This is not a data access question. Maybe you can put the question on SQL Server/TSQL forum