Re: trigger naming convention

Limin Guo wrote:
>
> Looks like a simple quesition. Would someone tell me what kind of
> naming convention for triggers, packages and procdures would be
> more meaningful and readable. Currently I am using trigger name's
> like:
>
> tablename_1_trg
>
> if I have more than one trigger on one table, I will use the number
> to replace 1 in the trigger name.
>
> Any reply would be highly appreciated.---

Choose the name of the Table plus the event when it's fired:

Example: Student_BIR (Before Insert Row trigger)

          Student_ADS (After Delete statement trigger) ... Received on Thu Jun 05 1997 - 00:00:00 CDT