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.