Home > Archive > SQL Anywhere database > May 2005 > Trigger problems upgrading









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]

 

Author Trigger problems upgrading
Lou Pompa

2005-05-23, 8:23 pm

Is there a way to display existing triggers in a database using iSQL?


Joshua Savill

2005-05-23, 8:23 pm

SELECT * FROM SYS.SYSTRIGGERS

This will give all the trigger information in the database.

--
Joshua Savill
iAnywhere Solutions - Product Support Analyst


"Lou Pompa" <lpompa@llgroup.net> wrote in message
news:42922af9$1@foru
ms-1-dub...
> Is there a way to display existing triggers in a database using iSQL?
>



Stephen Rice

2005-05-23, 8:23 pm

Sybase Central has the display capability. The best you can do in dbisql is
dump the contents of sys.systrigger

/steve

--
Stephen Rice
Technical Services Manager
iAnywhere Solutions
------------ Please Post -------------
"Lou Pompa" <lpompa@llgroup.net> wrote in message
news:42922af9$1@foru
ms-1-dub...
> Is there a way to display existing triggers in a database using iSQL?
>



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com