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