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.