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

Community · Accepted Answer · 2017-05-23 11:50:41Z

15

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, 2017 at 11:50

CommunityBot

11 silver badge

answered Jun 18, 2012 at 8:58

ThiefMaster

320k85 gold badges608 silver badges648 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user1458476 Over a year ago

Now that's what I call an answer

Martijn Pieters Over a year ago

@user1458476: We have SO as a knowledgebase, what do you expect? :-P

Collectives™ on Stack Overflow

Python DB API list tables

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related