user84
user84

Reputation: 885

Looking for a sql command to find active triggers, and their associated tables

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

Answers (0)

Related Questions