Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Jack Parker — — source: Usenet: comp.databases.informix
select tabname from systables.
For a more complete discussion of system catalogues see SQL ref manual
chapter 2 and/or
http://www-106.ibm.com/developerworks/db2/zones/informix/library/techarticle/0305parker/0305parker.html
cheers
j.
----- Original Message -----
From: "Xavier Autret" <xav_x@noos.fr>
To: <informix-list@iiug.org>
Sent: Wednesday, January 14, 2004 1: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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.