Re: meta data structure where?

The equivalent is systables. To list all tables use SELECT tabname FROM systables For more details of system tables see the Informix Guide to SQL: reference manual. As to posting the differences between Oracle and Informix statements I think you really need to read the Informix Guide to SQL: Syntax manual. I couldn't hope to define what is different between Oracle and Informix except that IMHO the Informix syntax is better. regards Malcolm ----- Original Message ----- From: "Xavier Autret" <xav_x@noos.fr> To: <informix-list@iiug.org> Sent: Wednesday, January 14, 2004 9:40 AM Subject: meta data structure where? > Hello, > > I'am comming from the Oracle world and I'am searching an equivalent > for: > > "SYS.ALL_TABLES" > > => a view or table that list all tables for my database. > > If you can also post the differences in SQL statements between > Oracle/informix that would be great! > > thanks! > > Xavier Autret sending to informix-list