Naming conventions for DB triggers

Question

Are there any naming conventions for DB triggers?

For example "before delete on users" would be "bdUsers" or something like that.

Answer 1

For sorting reasons I would recommend a structured approach:

TR_Users_AD
TR_Users_BD
TR_OtherTable_AI

and so on.

In the end it's up to you - but whatever you choose to do, stay consistent, at least within the same database.

Answer 2

I agree with @tomalak - but i normally spell out the action at the end instead of abbreviating it...

trig_Users_delete
trig_Users_insert
trig_OtherTable_Insert
trig_OtherTable_InsteadOfInsert