sybperl-l Archive

From: salvatore dot sferrazza at ny dot ubs dot com
Subject: Re: listing the tables
Date: Sep 19 1997 3:43PM

     query sysobjects table where type = "U"
     
     ( i may be wrong about the type ).
     
     HTH,
     
     Sal


______________________________ Reply Separator _________________________________
Subject: PUBLIC: listing the tables
Author:  tony (tony@vi.net) at nyux
Date:    9/19/97 11:23 AM


(this is guy@vi.net but I'm using Tony's SPARC....)
     
we have an application where we must create a table for 
each client, these tables will then be called client1_data, 
client2_data &c. But now we need a way to list all the 
tables in a database, and I can't find a way to do this 
using CTLib (the server runs under NT and the middle
tier is under Linux).
     
Could anyone please tell me how to get a list of 
all the tables within a particular database?
     
Thanks,
     
G