Re: DESCRIBE statement

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