Naming conventions for DB triggers Naming conventions for DB triggers database database

Naming conventions for DB triggers


For sorting reasons I would recommend a structured approach:

TR_Users_ADTR_Users_BDTR_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.


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

trig_Users_deletetrig_Users_inserttrig_OtherTable_Inserttrig_OtherTable_InsteadOfInsert