Question

Write a program to display list of tables created in a database? Example

Answer 1

import sqlite3

con= sqlite3 .connect(‘Academy.db’)

cursor = con.cursor( )

cursor.execute(“SELECT name FROM sqlitemaster WHERE type-table’;”)

print(cursor. fetchall( ))

OUTPUT

[(‘Student’ ,), (‘Appointment’ ,), (‘Person’ ,)]