Take a look at xCase (www.xcase.com) This tool will generate T-SQL code for your stored procedure to implement several types of referential integrity (cascade, ignore, set null). You just set the type of relationship between two tables and xCase takes care of the rest.

I have used for SQL Server 7 and the code generated is very elegant. I have seen that it provides templates for several other DBMS as well.

Code generated by xCase is based on a couple of templates that they provide out of the box. A neat thing in xCase is that you can modify those templates so the code will look more like a la :)

>Hello,
>
>I am trying to figure out how to do cascade deletes in SQL*Server 6.5/7.0 using a stored procedure (or what ever technique the database must use). In Oracle this is real easy since you can just use the following alter table command:
>
>alter table "ChildTableName"
>add constraint "ConstraintName_FK" foreign key (cid)
>references "ParentTable" (cid) on delete cascade ;
>
>What would I do in SQL*Server to make the same thing happen?
>Note: I tried to upsize the RI stuff from VFP6, but it seems the RI stuff had some errors.
>
>Thanks,
>
>Kevin
>
>P.S. I first posted this in the sql*server forum, but there doesn't seem to be too much traffic over there.

Hector Correa