Re: Equivalent to Oracle's describe

In <01bd5174$eb9c7f00$078a4ccf@borg.organic.com> "James Cooper" <pixel@organic.com> writes: >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. Use 'dbaccess <dbname> -' to get a command line prompt (like sqlplus), then use 'info [columns|indexes|?otherthings?] on <tablename>' for your table information. >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. :) Bloody Oracle head. >I imagine I could answer my first question above if I knew which catalog >tables >to look in. Not quite. The dbaccess manual and SQL Syntax manual has the goods for your first question, but certainly investigate the sysmaster database tables and the sys* tables in the individual user databases. There's tons of useful stuff in these, and sysmaster is almost indispensable for formatting home grown performance and monitoring tools. >thanks >-- James -- Bryan Tonnet batonnet@phase4.com.au