Python Practice › SQLite Programs › Program 15
Column names of a query
Write a Python program to print the column names of a query result.
Output
['id', 'name', 'email']
Approach
cursor.description.
Solution
import sqlite3 conn = sqlite3.connect(":memory:")conn.execute("CREATE TABLE users (id INTEGER, name TEXT, email TEXT)")cur = conn.execute("SELECT * FROM users")print([col[0] for col in cur.description])Output
['id', 'name', 'email']
Learn the concept
New to this topic? Read the lesson, then come back.