Reputation: 885
I am trying to find active triggers and their associated tables in Sybase. What would be a written query?
I found the following SQL command useful
select * from sysobjects where type = "TR" where deltrig =1 or instrig = 1 or updtrig =1
But, I do not know how to associate the trigger name with the name of a table.
Upvotes: 0
Views: 151