Re: Trgger Question

KPonn wrote: } Hi } } I have four tables A,B,C, and D with prod_number. I am trying to write a } trigger to delete prod-numbers from B,C, and D if I delete a prod_number from } A. Since I can only have one delete triggrer on A , I have the following: } } create trigger ....... delete on A ....... } for each row ( } delete from B; } delete from C; } delete from D; } ) } } Is it possible to do the above or do I need a stored procedure (called from a } <snip> Hi-Keith, You don't need any stored procedure to get it done, with a slight modification to your statement, you are there : create trigger trig_name delete on A [ optional_referencing_clause ] foreach row (delete from B where .... ), -- Notice this use of "," (delete from C where .... ), -- Notice this use of "," (delete from D where .... ); -- And this ";" -- Have a nice day Felix K. Mathews mailto:fmathews@systems.dhl.com