Reposting -- used open/close brackets for names below and they got truncated.


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

I believe this is my first post on the SQL*Server forum.