Re: Delete trigger deletes an entire table

[irek kordirko]

Use OLD keyword to access data from record that is being deleted.

delete from ProcFamClass where ProcFamClass.proc_id = OLD.proc_id;