Trigger symbol on tables and views in object explorer
In SSMS Object Explorer, you can find DML triggers by expanding the table (or view) and then expanding the Triggers node. That is fine.
However, it would be great to have a visual indication, as a kind of warning, on the table or view symbol. This symbol should only appear on tables and views that have one or more active triggers
My suggestion for the symbol would be a lightning bolt (similar to the icon used for the actual triggers). Preferably in red.
Sounds like a brilliant idea
Brilliant idea. Even better, customise the icon depending on the type(s) and number(s) of the associated trigger(s).
Love this idea, I've been caught out plenty of times by unexpected triggers!
I guess this might useful if your databases have few DML triggers. Our databases use trigger based archiving, so most of our tables would have the trigger overlay. Thus, the overlays would not help us figure out which tables have those "business logic" triggers that we forget about and cause the mysterious behavior for which a reminder would be useful.