How to get all tables from sqlite3 database?

Question

Python

There is a database base how to display all the tables that are there?

Answer 1

con = sqlite3.connect("data.db")
cursor = con.cursor()

cursor.execute("SELECT name FROM sqlite_master WHERE type='table';")
print(cursor.fetchall())

Answer 2

show tables;