Do you have a comment or suggestion to improve SQL Server? We’d love to hear it!

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.

30 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Hugo Kornelis shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    4 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • Anonymous commented  ·   ·  Flag as inappropriate

        Brilliant idea. Even better, customise the icon depending on the type(s) and number(s) of the associated trigger(s).

      • JediSQL commented  ·   ·  Flag as inappropriate

        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.

      Feedback and Knowledge Base