Navigating to trigger source

[sumsar]

What is the easiest way to view triggers on a table, when the table name is in a program window, eg. in an select clause??

Right click on the table name only allows you to view the table, not the triggers.

Rasmus

 

[whip]

I think, the easiest is: Right click -> Browse and then open the Triggers folder.
Or: create a new menu item with the Browser Extender plugin.

 

[sumsar]

Thanks!

Just one problem, I normally run with the browser filter "My objects", because my database is quite large. If I try to "Browse" an object in an other schema it fails, meaning I still have to select "Users//Objects/Tables/Triggers" to get to the trigger source.

Rasmus

 

[Kent]

You can use the browser extender plug-in to create a right-button menu item that will show all triggers on a table or view. The plug-in comes with an item to show all indexes; just pattern a new item after that and use this as the action:

Select t.trigger_name,t.trigger_type,t.triggering_event,t.status
From All_Triggers t
Where t.Table_Owner = '#oowner' And t.table_name = '#oname'