Re: SQL Editor and table Descriptions

Posted in 1999

Mark D. Stock — Fri, 12 Mar 1999 09:59:46 +0200 — source: Informix-list mailing list archive (1991-1998)

Obnoxio The Clown wrote: > > >Does anyone know the commands to get the field names and sizes when > >using Informix SQL Editor? I knew there was a command for Oracle and > >Sybase but can't seem to find one for Informix... > > INFO COLUMNS FOR table-name Come now, INFO is an ISQL/DBACCESS command. You should look at the Database Explorer, not SQL Editor for this info. Cheers, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com http://www.informix.com/idn |///// / //| |http://www.iiug.org +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 838250 2325 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+