Check if a Database is Empty (No Tables) in SQLAlchemy

Question

How can I check if a database is empty in SQLAlchemy?

I know you can do inspector.dialect.has_table(engine.connect(), 'table_name') to check for the existence of a single table, but I want to know if there are any tables at all in the database.

Oghli · Accepted Answer · 2022-01-05 13:12:57Z

1

You can check tables in current database:

db.engine.table_names()

or after creating engine variable from connection string:

engine = sql.create_engine("connection_string")

sql.inspect(engine).get_table_names()

edited Jan 5, 2022 at 13:12

answered Jan 5, 2022 at 11:39

Oghli

2,4111 gold badge18 silver badges42 bronze badges

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

2 Comments

Minura Punchihewa Over a year ago

For the scenario I have mentioned, as you have said, if db.engine.table_names() seems to work fine. Thanks!

Oghli Over a year ago

@MinuraPunchihewa Good. mark the answer as accepted if your problem solved.

Collectives™ on Stack Overflow

Check if a Database is Empty (No Tables) in SQLAlchemy

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related