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 add constraint foreign key (cid) references (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.