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. > Until then, you could try this command: dbschema -d <database name> -t <table name> 1. This can be piped to "more" or "pg" or redirected to a file. 2. If you add the switch -ss, it will also give you additional "server-specific" information, such as what dbspace the table resides in, first and next extent information also. This will give you a bit to go on. John Carlson Informix DBA WH Smith, Inc.