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: 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