How to find list of triggers that are existed on a table. I am using sybase ASE 15-2 -
how find list of triggers existed in table. using sybase ase 15-2
i tried
exec sp_depends 'dbo.mytable'
i getting errors..
1- check sp_depends exists:
use sybsystemprocs go sp_help sp_depends go
2- check version of sp_depends in installmaster corresponds ase version
use master go sp_version -- @ version of installmasater go select @@version -- @ version of ase go -- if not same version, run installmaster script (check in test first)
2- run commands:
use <dbname> go exec sp_depends 'mytable' or sp_depends mytable go
Comments
Post a Comment