How to list tables in access database?

baztian / jaydebeapi

JayDeBeApi module allows you to connect from Python code to databases using Java JDBC. It provides a Python DB-API v2.0 to that database.

GNU Lesser General Public License v3.0

364 stars 147 forks source link

How to list tables in access database? #215

Open mwiertz opened 2 years ago

mwiertz commented 2 years ago

Hi,

I'm trying to retrieve a list of tables from an MS Access mdb database file from Python using JayDeBeApi combined with UCanAccess. Querying the database works fine, though I cannot find out how top list all tables. I've been googling and trying for days now, but was not able to find a solution.

Anyone can help?

Thanks, best, Max

deweydb commented 10 months ago

Did you ever figure this out? stuck on the same thing.

mwiertz commented 10 months ago

Unfortunately, no. Ended up working around it by converting the databases to sqlite... Bit drastic to do over and over again, but couldn't find another solution.

deweydb commented 10 months ago

I figured it out: select * from information_schema.tables It seems ucanaccess actually "copies" the original .mdb to an hsqldb one at connection time.