On Wed 2001/10/10 18:29:04 CDT, Bob Tanner <tanner at real-time.com> writes:
> I'm looking for a tool under linux that can figure out database schemas when 
> all
> you got is an ODBC datasource.

What is the database behind the ODBC datasource?  There is no uniform way 
of extracting a schema from a database.  Oracle's info is all stored in the 
sys_* views and/or v$* tables.  Sybase's info is all stored in dbo.sys* 
tables.  MS SQL Server is probably similar to Sybase (or, at least, it was 
identical at one point).

There is a Perl script called dbschema.pl floating around the internet that 
will extract the schema from a Sybase database -- you could probably modify 
this if the "real" database is Sybase.  There are probably similar scripts 
for other databases.