Python DB API list tables

Question

How do I list a DB's tables with Python's DB API?

Failing that, is there another way to do it?

Thanks

score 14 · Accepted Answer · edited May 23 '17 at 11:50

14

The DBAPI does not have a function for this so unfortunately you need to use SQL that is specific to the database engine (there is no standardized way to list tables).

MySQL: SHOW TABLES
PostgreSQL: SELECT tablename FROM pg_tables WHERE schemaname = 'public'
SQLite: SELECT name FROM sqlite_master WHERE type = 'table'
MS SQL: SELECT Distinct TABLE_NAME FROM information_schema.TABLES
Oracle: SELECT table_name FROM all_tables
SAP HANA: SELECT table_name FROM tables

edited May 23 '17 at 11:50

Community

1
1

answered Jun 18 '12 at 08:58

ThiefMaster

298,938
77
579
623

Now that's what I call an answer – user1458476 Jun 18 '12 at 09:09
@user1458476: We have SO as a knowledgebase, what do you expect? :-P – Martijn Pieters Jun 18 '12 at 09:22

Python DB API list tables

1 Answers1