You can also use the following command in dbaccess / isql:



info columns for <your_table>







-----Original Message-----

From: owner-informix-list@iiug.org [mailtowner-informix-list@iiug.org] On Behalf Of Madison Pruet

Sent: Tuesday, January 27, 2004 7:28 PM

To: informix-list@iiug.org

Subject: Re: DESCRIBE statement (table info)



Check out <table> -> <info> . This will display similar information as the

Describe command.



N.B. the describe sommand is actually a valid sql command that is usually

used with SCLDA structures that is used by dynamic queries. These are

required by things such as ODBC and JDBC drivers to provide a generic

interface to a DBMS.



The usage of dbschema will return the definition of the view as well as

which tables make up the view.



"Xavier Autret" <xav_x@noos.fr> wrote in message

news:f76de91b.0401270224.59626998@posting.google.c om...

> Hello,

>

> In many DMBS we ve got the DESCRIBE statement.

>

> I've got an informix view and I want to see the code that define my view.

> I tried DESCRIBE <table> in dbaccess but an error occured.

>

> I don't want to see the columns but the code stored in the view.

>

> Perhaps it is stored in a systeme table?

>

> Xavier








________________________________

<< ella for Spam Control >> has removed 985 Spam messages and set aside 167 Newsletters for me
You can use it too - and it's FREE! www.ellaforspam.com

sending to informix-list