Re: List of table names

Posted in 1997

Jonathan Leffler — 27 May 1997 12:23:32 -0400 — source: Informix-list mailing list archive (1991-1998)

>Date: Tue, 27 May 1997 17:06:18 +0100 >From: "Aquilina Jean Pierre at MSU" <Jean.Pierre.P.Aquilina@magnet.mt> >X-Informix-List-Id: <list.14653> > >I need to get a list of tables from a database using ESQL/C. I am using >Informix version 5. How can I do this? Process the output from: SELECT Owner, TabName FROM 'informix'.SysTables WHERE TabType = 'T'; This ignores views and synonyms; if you want them too, extend the WHERE clause accordingly. Unless your database is a MODE ANSI database, the Owner information is not needed to identify the tables uniquely. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>