PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Kiril Mitev <kiril at idea-globalmarket dot com>
Subject: Re: listing the tables
Date: Sep 19 1997 5:53PM

> 
> (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
> 
> 
> 
I could be off by a byte, but try
select name from sysobjects where type like 'U'

KM