Re: List of table names

You may also want to include 'and tabid > 99', unless you want to see the system catalogue tables, as well. David }>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>