Re: How to get only the user table names from systables
joseph v d'silva wrote:
> 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.
SELECT tabname
FROM systables
WHERE tabid > 99
AND tabtype = "T"
Cheers,
--
Mark.
+----------------------------------------------------------+-----------+
| Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /|
| Mydas Solutions Ltd http://MydasSolutions.com |///// / //|
| +-----------------------------------+//// / ///|
| |We value your comments, which have |/// / ////|
| |been recorded and automatically |// / /////|
| |emailed back to us for our records.|/ ////////|
+----------------------+-----------------------------------+-----------+
sending to informix-list