|
Home > Archive > ASE Database forum > October 2005 > sp_helptrigger
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Frank Rizzo 2005-10-27, 8:21 am |
| I am sorry for continuing to ask ms-centric question, but I am migrating
an app from mssql to sybase ase, so here it goes...
Mssql has a handy sproc called sp_helptrigger which basically returns a
list of triggers belonging to a certain table, whether they are for
update/insert/delete and whether the trigger is enabled.
How can I obtain this information from system tables in ase 12.x and/or
15.x?
Thanks
| |
|
| Ed Barlow maintains a web site that contains a number of
available procedures (http://www.edbarlow.com). You may
wish to check there for your needs. I have found some to be
quite valuable.
> I am sorry for continuing to ask ms-centric question, but
> I am migrating an app from mssql to sybase ase, so here
> it goes...
>
> Mssql has a handy sproc called sp_helptrigger which
> basically returns a list of triggers belonging to a
> certain table, whether they are for update/insert/delete
> and whether the trigger is enabled.
>
> How can I obtain this information from system tables in
> ase 12.x and/or 15.x?
>
> Thanks
| |
| Mark A. Parsons 2005-10-27, 8:21 am |
| I can't answer for 15.x but for all prior versions ... check the
contents of sysobjects; there are 3 seperate columns(deltrig, instrig,
updtrig), each of which will contain an object id if such a trigger exists.
I usually 'just' whip up a quick sp_helptrigger which performs an
object_name(<id_value> ) on each of the 3 columns. If I'm feeling really
energetic I'll add an 'exec sp_helptrigger' to the sp_help code.
Frank Rizzo wrote:
> I am sorry for continuing to ask ms-centric question, but I am migrating
> an app from mssql to sybase ase, so here it goes...
>
> Mssql has a handy sproc called sp_helptrigger which basically returns a
> list of triggers belonging to a certain table, whether they are for
> update/insert/delete and whether the trigger is enabled.
>
> How can I obtain this information from system tables in ase 12.x and/or
> 15.x?
>
> Thanks
|
|
|
|
|