Re: How to get only the user table names from systables

SELECT * FROM systables WHERE tabid > 99 will do exactly what you need. Malcolm ----- Original Message ----- From: "joseph v d'silva" <j_v_dsilva@www.com> To: <informix-list@iiug.org> Sent: Thursday, August 21, 2003 9:36 AM Subject: How to get only the user table names from systables > Hi, > > I am planning to write a shell script that will unload all user > tables from a database, but for this I require to get all the > usertable names, now the problem is that the systables lists system > tables also. On the other hand if you go to dbaccess where the table > info is listed, you will have only user tables listed. I want to know > how dbaccess works out this "magic" of distinguishing system tables > and usertables. > > Thankx > > joe sending to informix-list