Oninit cdi / Archive
Talk to an expert →

Re: Informix Triggers

Posted in 1999

Topics: Server Administration, Triggers, Constraints & Referential Integrity, Platform-Specific Issues, Versions, Editions & End-of-Life

ayyasamy subramanian — — source: Informix-list mailing list archive (1991-1998)

Hi From dbaccess select the info of table and select tri<G>gers from the selection. It will list down all the triggers that are all for the table . good luck swami >From: m.iacobellis@usa.net >Reply-To: m.iacobellis@usa.net >To: informix-list@iiug.org >Subject: Re: Informix Triggers >Date: Mon, 08 Mar 1999 16:55:00 GMT > >In article <7c0ejd$64u$1@nclient1-gui.server.virgin.net>, > "william.downie" <william.downie@virgin.net> wrote: >> Please Help ! >> >> How can I see what triggers are attached to a table ? >> >> I have tried using dbschema, but it does not show what triggers are attached >> to the table ! >> >> Are there any good sites on how to program triggers, or any good books which >> you can >> download on informix triggers/procedures >> >> Thanks >> >> Will Downie >> >> > >William, > >on my system ( IDS 7.13, AIX 4.2.1 ) dbschema works fine: > >dbschema -d <db name> -t <table name>> >You can also use dbaccess: > >dbaccess <dbname> <CR> <T>able <I>nfo tri<G>gers ... > >Anyway, don't forget to specify the version of your Engine / S.O. > >HTH > >Michele > >-----------== Posted via Deja News, The Discussion Network ==---------- >http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own > Get Your Private, Free Email at http://www.hotmail.com

Glossary