query to return table structure

hi, Is there any command or query that returns the table structure informix. like the DESC command that works in Oracle. -- Posted via http://dbforums.com

On Wed, 17 Sep 2003 08:28:41 -0400, fxthomas <member39970@dbforums.com> wrote: > >hi, > > > > Is there any command or query that returns the table structure > > informix. > > > > > > like the DESC command that works in Oracle. run 'dbschema' from the command line . . . .

fxthomas wrote: > Is there any command or query that returns the table structure > informix. like the DESC command that works in Oracle. As wel as the DB-Schemea command already mentioned by two people, you can also use the INFO statement in DB-Access. On average, I prefer the information from DB-Schema, but both are usable. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/