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: Michael Peppler <mpeppler at peppler dot org>
Subject: Re: listing tables from within DBD::Sybase
Date: Sep 27 2001 8:23PM

ed phillips writes:
 > Hi Michael,
 > 
 > First of all, thanks for a great tool. I've been using the jdbc driver,
 > but I'm happy and relieved to have a DBD driver available for Sybase.
 > 
 > I have a question that I did not see addressed in the docs. I've got a
 > remote database I'm working with. Is there a command callable from
 > DBD::Sybase that will give me a list of the tables in my database; does
 > this command also work on MSSQL databases?

Well - that depends on whether the MSSQL server has the "sp_tables"
proc.

If it does, then you can use $dbh->table_info(...) - see the DBI docs
for details.

If it doesn't, then do a select name from sysobjects where type = 'U'
to get a list of tables in a database.

Michael
-- 
Michael Peppler - Data Migrations Inc. - http://www.mbay.net/~mpeppler
mpeppler@peppler.org - mpeppler@mbay.net
International Sybase User Group - http://www.isug.com