RE: query to return table structure

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@dbforums.com] > Sent: Wednesday, September 17, 2003 5:59 PM > To: informix-list@iiug.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

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: > > > 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@dbforums.com] >> Sent: Wednesday, September 17, 2003 5:59 PM >> To: informix-list@iiug.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