Python: List the tables of given SQLite database file

Last update on April 02 2025 12:40:44 (UTC/GMT +8 hours)

4. List SQLite Tables

Write a Python program to list the tables of given SQLite database file.

Sample Solution:

Python Code :

import sqlite3
from sqlite3 import Error
def sql_connection():
   try:
     conn = sqlite3.connect('mydatabase.db')
     return conn
   except Error:
     print(Error)
 
def sql_table(conn):
   cursorObj = conn.cursor()
# Create two tables
   cursorObj.execute("CREATE TABLE agent_master(agent_code char(6),agent_name char(40),working_area char(35),commission decimal(10,2),phone_no char(15) NULL);")
   cursorObj.execute("CREATE TABLE temp_agent_master(agent_code char(6),agent_name char(40),working_area char(35),commission decimal(10,2),phone_no char(15) NULL);")
   print("List of tables:")
   cursorObj.execute("SELECT name FROM sqlite_master WHERE type='table';")
   print(cursorObj.fetchall())
   conn.commit()
sqllite_conn = sql_connection()
sql_table(sqllite_conn)
if (sqllite_conn):
 sqllite_conn.close()
 print("\nThe SQLite connection is closed.")

Sample Output:

List of tables:
[('agent_master',), ('temp_agent_master',)]

The SQLite connection is closed.

For more Practice: Solve these Related Problems:

Write a Python program to connect to a given SQLite database file and list all the table names by querying sqlite_master.
Write a Python script to print detailed schema information for all tables in a SQLite database.
Write a Python function that takes a SQLite file path as input, retrieves all table names, and returns them in a sorted list.
Write a Python program to check if a specific table exists in a SQLite database and print an appropriate message.

Python Code Editor:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: Write a Python program to connect a database and create a SQLite table within the database.
Next: Write a Python program to create a table and insert some records in that table. Finally selects all rows from the table and display the records.