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.