Re: Equivalent to Oracle's describe
James Cooper wrote:
>
> Hi,
>
> I'm new to the Informix world, and miss the "describe" command in Oracle
> that
> displays the column names and datatypes for a given table or view.
>
> I realize that if I run dbaccess in its menu driven mode that I can get
> this
> information, but for whatever reason I'm just not that into the fancy ASCII
> menus.
>
> Also, can anyone recommend a good reference for the Informix system
> catalog?
> I imagine I could answer my first question above if I knew which catalog
> tables
> to look in.
>
> thanks
>
> -- James
Try the INFO command in dbaccess:
INFO {TABLES | COLUMNS FOR table-name
| INDEXES FOR table-name | STATUS FOR table-name
| {ACCESS | PRIVILEGES | REFERENCES} FOR table-name}
--
Peter Lancashire
Information Systems Specialist, Bayer plc
Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK
Tel: +44-1635-562258, Fax: +44-1635-562281
Mail: Peter.Lancashire.PL1@bayer.co.uk
My Internet plumbing does not allow me to mail and post news together.
Sorry.
All opinions are my own and not those of Bayer plc.