Re: How do I find triggers associated to a table

#1

blackscooby (AT) btinternet (DOT) com (Mark Warren) wrote in message news:<83288e0.0306262345.3ace46ce (AT) posting (DOT) google.com>...

Quote:

Hi,

How can I find what triggers are associated to a particular table ?
(ASE 11.5.1)

Thanks

Mark

The sysobjects row for the table will have the object ids
of the triggers in the "instrig", "updtrig", and "deltrig" fields.

-bret

#2

blackscooby (AT) btinternet (DOT) com (Mark Warren) wrote in message news:<83288e0.0306262345.3ace46ce (AT) posting (DOT) google.com>...

Quote:

Hi,

How can I find what triggers are associated to a particular table ?
(ASE 11.5.1)

Thanks

Mark

One easy way is to install sybase central. It will easily show you
all triggers for a particular table. Winsql will do this is well. Im
sure someone else will post the system table query that will get it
for you.

jab

#3

DBPowerSuite's psListTables and psListTablesForWeb tells you everything
associated with a table, including triggers. DBPowerSuite can also list the
text of the triggers, copy triggers, etc.

Free download and license at http://www.dbpowersuite.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: How do I find triggers associated to a table

comp.databases.sybase comp.databases.sybase

Re: How do I find triggers associated to a table - 06-27-2003 , 09:39 AM

Re: How do I find triggers associated to a table - 06-27-2003 , 11:07 AM

Re: How do I find triggers associated to a table - 07-02-2003 , 11:39 PM