sybperl-l Archive

From: "HANSON,DENNIS (HP-Roseville,ex1)" <dennis_hanson at hp dot com>
Subject: RE: listing tables from within DBD::Sybase
Date: Sep 27 2001 7:24PM

HI Ed,

You will probably have to do a select from the sysdatabases table, like so:

select name from sysdatabases
order by name



I don't think DBD-Sybase has a specific command or routine that returns
table names.


Dennis

-----Original Message-----
From: ed phillips [mailto:artlore@sirius.com]
Sent: Thursday, September 27, 2001 12:11 PM
To: SybPerl Discussion List
Subject: listing tables from within DBD::Sybase


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?

Thank you,

Ed