>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.

You could put a trigger on the table to delete child records.