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

No comments:

Post a Comment