>...You could put a trigger on the table to delete child records...
>
>I hate show my ignorance (and I did look thru some of the documentation), but what does the syntax for a casecade delete trigger look like?
>
>Kevin
create trigger ParentDeleteTrig
on Parent
for delete as
begin
/* RI to keep tables in sync */
delete Children
from Children C, deleted D
where D.ID = C.PARENTID
delete ...
end
where Parent is parent table name, children is children name, id fields are foreign keys.
Hope this helps
Mace
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement