|
|
sybperl-l Archive
Up Prev Next
From: Michael Peppler <mpeppler at MBAY dot NET>
Subject: Re: listing the tables
Date: Sep 19 1997 4:06PM
Tony Wong wrote:
>
> (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?
select name from sysobjects where type = 'U'
You can also take a look at dbschema.pl - it gets a number of things
from the system tables...
Michael
--
Michael Peppler -||- Data Migrations Inc.
mpeppler@datamig.com -||- http://www.mbay.net/~mpeppler
|
