import sqlite3 conn = sqlite3.connect('cms.db') c = conn.cursor() c.execute("PRAGMA table_info(nav_menus)") for row in c.fetchall(): print(row) print('\n--- data ---') c.execute("SELECT * FROM nav_menus") for row in c.fetchall(): print(row) conn.close()