from sqlite3 import *

with connect("schule.db") as con:
    tables = con.showTables()
    for table in tables:
        print("\nTable:", table)
        print(con.describeTable(table))