select *
from systables
where tabid > 99
and tabtype = 'T'

will get you tables. Without the tabtype qualifier you will get views as
well.

Mark

----- Original Message -----
From: "joseph v d'silva" <j_v_dsilva@www.com>
To: <informix-list@iiug.org>
Sent: Thursday, August 21, 2003 04:36
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