sybperl-l Archive

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.

dowen

    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.      dowen@midsomer.org
Maintainer of the Sybase FAQ: http://www.isug.com/Sybase_FAQ