query to return table structure

#1

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

#2

On Wed, 17 Sep 2003 08:28:41 -0400, fxthomas
<member39970 (AT) dbforums (DOT) com> wrote:

Quote:

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 . . . .

#3

This is a multi-part message in MIME format.

------=_NextPartTM-000-991f02a3-9bf1-4560-a1ad-2490eb0c6a93
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

dbschema -d <dbname> -t <table name>

Quote:

-----Original Message-----
From: fxthomas [mailto:member39970 (AT) dbforums (DOT) com]
Sent: Wednesday, September 17, 2003 5:59 PM
To: informix-list (AT) iiug (DOT) org
Subject: query to return table structure
=20
=20
=20
hi,
=20
=20
=20
Is there any command or query that returns the table structure
=20
informix.
=20
=20
=20
=20
=20
like the DESC command that works in Oracle.
=20
=20
--
Posted via http://dbforums.com
=20

------=_NextPartTM-000-991f02a3-9bf1-4560-a1ad-2490eb0c6a93
Content-Type: text/plain;
name="InterScan_Disclaimer.txt"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
filename="InterScan_Disclaimer.txt"

This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information.
If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Any unauthorised review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly
prohibited and may be unlawful.

Visit us at http://www.cognizant.com

------=_NextPartTM-000-991f02a3-9bf1-4560-a1ad-2490eb0c6a93--
sending to informix-list

#4

fxthomas wrote:

Quote:

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 (AT) earthlink (DOT) net, jleffler (AT) us (DOT) ibm.com
Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/

#5

56 lines of crap for a one-line reply. Let me see if I can better that. Yes,
if I include the whole wasteful post in my reply, I think I can.

Rastogi, Asheesh (Cognizant) wrote:

Quote:

This is a multi-part message in MIME format.

------=_NextPartTM-000-991f02a3-9bf1-4560-a1ad-2490eb0c6a93
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

dbschema -d <dbname> -t <table name

-----Original Message-----
From: fxthomas [mailto:member39970 (AT) dbforums (DOT) com]
Sent: Wednesday, September 17, 2003 5:59 PM
To: informix-list (AT) iiug (DOT) org
Subject: query to return table structure
=20
=20
=20
hi,
=20
=20
=20
Is there any command or query that returns the table structure
=20
informix.
=20
=20
=20
=20
=20
like the DESC command that works in Oracle.
=20
=20
--
Posted via http://dbforums.com
=20

------=_NextPartTM-000-991f02a3-9bf1-4560-a1ad-2490eb0c6a93
Content-Type: text/plain;
name="InterScan_Disclaimer.txt"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
filename="InterScan_Disclaimer.txt"

This e-mail and any files transmitted with it are for the sole use of the
intended recipient(s) and may contain confidential and privileged
information. If you are not the intended recipient, please contact the
sender by reply e-mail and destroy all copies of the original message. Any
unauthorised review, use, disclosure, dissemination, forwarding, printing
or copying of this email or any action taken in reliance on this e-mail is
strictly prohibited and may be unlawful.

Visit us at http://www.cognizant.com

------=_NextPartTM-000-991f02a3-9bf1-4560-a1ad-2490eb0c6a93--
sending to informix-list

--
"C'est pas parce qu'on n'a rien à dire qu'il faut fermer sa gueule"
- Coluche

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

query to return table structure

comp.databases.informix comp.databases.informix

query to return table structure - 09-17-2003 , 07:28 AM

Re: query to return table structure - 09-17-2003 , 08:33 AM

RE: query to return table structure - 09-17-2003 , 09:22 AM

Re: query to return table structure - 09-17-2003 , 10:39 AM

RE: query to return table structure - 09-17-2003 , 11:11 AM