Microsoft SQL 2005: I just created a trigger but it won't show me the code under "Database triggers"?

Once you create a trigger with the create trigger code, how do you get it to show up in the "Database Triggers" folder? I refresh and nothing shows. I know it's there because I can see two database开发者_如何转开发 counts when I update the table.

---

You will be able to find the trigger undeer the table structure itself.

Expand the table, you will see something like Columns, Keys, Constraints, Triggers, Indexes, Statistics. It will be under the Triggers section.