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.