You can display all of the triggers in a database in the Object List Viewer, and open, modify, disable, or drop a trigger from that view. If you want to create a new trigger, you must first show the table on which you want to define the trigger.
- In the Navigator, double-click the Databases category.A list of the databases and users in the connected system appears in the Object List Viewer. The list is filtered according to any filters you have applied.
- Right-click a database or user, and click Show Triggers.The triggers in the database are displayed. The display includes a Table Database column indicating the database containing the table on which the trigger is defined.