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

1.	Write a program to display list of tables created in a database? Example
Answer» 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’ ,)]

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

Answer»

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’ ,)]