Up Prev Next
From: David Owen <dowen at midsomer dot org>
Subject: RE: listing tables from within DBD::Sybase
Date: Sep 27 2001 8:17PM
>>>>> "Dennis" == HP-Roseville,ex1 writes:
I think that you meant sysobjects. sysdatabases contains the set of
databases and is only to be found within the master database. sysobjects
contains the name (and other information) of most things with each database
within the server.
select name from sysobjects where type = 'U'
will return the set of User tables. type = S for system tables, P for
procs and so on.
Dennis> HI Ed, You will probably have to do a select from the
Dennis> sysdatabases table, like so:
Dennis> select name from sysdatabases order by name
David Owen Midsomer Consultants Inc. firstname.lastname@example.org
Maintainer of the Sybase FAQ: http://www.isug.com/Sybase_FAQ