Multiple Databases for ODBC adapter?

[schlich]

Hello! what a wonderful tool. I was wondering if you had plans on supporting multi-db servers in the Data Catalog pane? Usually (i.e. for SSMS/SQL Server) I see all of my server's databases listed-- maybe I am missing something, but I think I've looked through all the docs and help menus!

[tconbeer]

To be honest, I don't know how to enable this! I've tried using both pyodbc's cursor.tables() and querying information_schema.schemata, and both only return info on the currently-connected database (if there is a database in the connection string, or the "master" database otherwise) (at least on SQL Server on Azure).

If anybody knows how to query for the full list of all databases, I'd be grateful.

[schlich]

Stack Overflow seems to suggest

SELECT name FROM master.dbo.sysdatabases

Is that relevant?

[tconbeer]

Yes!

[tconbeer]

of course this is sql-server specific; oracle and others don't have this. But we could try it and follow that path if the query succeeds. We would then have to iterate over the list of returned dbs and make multiple calls to <db>.information_schema.tables . Not that hard, just annoying that there isn't an odbc-standard way of doing this.

[schlich]

I'm certainly down to put in a PR for this "when some time frees up" 😉 (but actually)

[tconbeer]

That would be much appreciated