Re: meta data structure where?
Posted in 2004
Topics: General Discussion
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