Python DB API List Tables

Question

How do I list DB tables with Python API?

If this is not the case, is there any other way to do this?

thanks

Answer 1

DBAPI has no function for this, so unfortunately you need to use SQL specific to the database engine (there is no standard way to display 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