query to return table structure
This is a discussion on query to return table structure within the Informix forums, part of the Database Server Software category; --> hi, Is there any command or query that returns the table structure informix. like the DESC command that works ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-19-2008, 06:47 PM
| ||||
| ||||
 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      |
|
04-19-2008, 06:47 PM
| |||
| |||
| Re: query to return table structure 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 . . . . |
|
04-19-2008, 06:47 PM
| ||||
| ||||
| Re: query to return table structure 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/ |
Linear Mode
