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

Popular posts from this blog

c# - Send Image in Json : 400 Bad request -

jquery - Fancybox - apply a function to several elements -

An easy way to program an Android keyboard layout app -