Re: viewing Trigger code

Posted in 2000

Topics: Triggers, Constraints & Referential Integrity

Obnoxio The Clown — Thu, 22 Jun 2000 13:19:13 BST — source: Informix-list mailing list archive (1991-1998)

From: jbcamel@mediaone.net > >I am using triggers for the first time. I've created two triggers and >have tested them successfully. Since they become part of the database I >was wondering how to view the trigger code. For example, I can see the >table definition with the 'dbschema' command. I can see the columns, >indexes and other information with the 'info status for', 'info columns >for', etc. Is there anything comparable for triggers? Yes. dbschema ________________________________________________________________________Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

↪ replying to Obnoxio The Clown

jblatz2@my-deja.com — Thu, 22 Jun 2000 14:18:27 GMT — source: Informix-list mailing list archive (1991-1998)

and you certainly are.... In article <8it1tr$msu$1@news.xmission.com>, "Obnoxio The Clown" <obnoxio@hotmail.com> wrote: > > From: jbcamel@mediaone.net > > > >I am using triggers for the first time. I've created two triggers and > >have tested them successfully. Since they become part of the database I > >was wondering how to view the trigger code. For example, I can see the > >table definition with the 'dbschema' command. I can see the columns, > >indexes and other information with the 'info status for', 'info columns > >for', etc. Is there anything comparable for triggers? > > Yes. > > dbschema> ________________________________________________________________________ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com > > Sent via Deja.com http://www.deja.com/ Before you buy.