RE: DESCRIBE statement (table info)

You can also use the following command in dbaccess / isql: info columns for <your_table> -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-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.com... > 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