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

Answer 1

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