List of tables, db schema, dump etc using the Python sqlite3 API

by

In Python:

con = sqlite3.connect('database.db')
cursor = con.cursor()
cursor.execute("SELECT name FROM sqlite_master WHERE type="table";")
print(cursor.fetchall())

Watch out for my other answer. There is a much faster way using pandas.

More Related Contents:

  1. Variable table name in sqlite
  2. SQLite parameter substitution problem
  3. Importing a CSV file into a sqlite3 database table using Python
  4. Django: Deploying an application on Heroku with sqlite3 as the database
  5. How do you escape strings for SQLite table/column names in Python?
  6. How to retrieve inserted id after inserting row in SQLite using Python?
  7. python 3.2 UnicodeEncodeError: ‘charmap’ codec can’t encode character ‘\u2013’ in position 9629: character maps to
  8. How to load existing db file to memory in Python sqlite3?
  9. Sqlite insert query not working with python?
  10. Python SQLite parameter substitution with wildcards in LIKE
  11. Inserting a table name into a query gives sqlite3.OperationalError: near “?”: syntax error
  12. Using a WHERE ___ IN ___ statement
  13. Python insert numpy array into sqlite3 database
  14. Python SQLite: database is locked
  15. How to discover table properties from SQLAlchemy mapped object
  16. Auto Increment on Composite Primary Key – Sqlite3 + Python
  17. How to get a single result from a SQL query in python?
  18. Parameter unsupported when inserting int
  19. Executing an SQL query over a pandas dataset
  20. SQLite Performance Benchmark — why is :memory: so slow…only 1.5X as fast as disk?
  21. Being that string substitution is frowned upon with forming SQL queries, how do you assign the table name dynamically?
  22. Pretty print JSON dumps
  23. creating a database outside the application context
  24. Why do you need to create a cursor when querying a sqlite database?
  25. sqlite3.ProgrammingError: You must not use 8-bit bytestrings unless you use a text_factory that can interpret 8-bit bytestrings
  26. SQLite, python, unicode, and non-utf data
  27. Python and SQLite: insert into table
  28. Pycharm environment different than command line
  29. Can’t change system default SQLite binary
  30. Django: sudden DB reset after Heroku sleep

Leave a Comment