gistfile1.py

>>> import sqlite3
>>> conn = sqlite3.connect(':memory:')
>>> cursor = conn.cursor()
>>> cursor.execute('CREATE TABLE demo (foo PRIMARY KEY, bar INTEGER, spam TEXT, eggs INTEGER NOT NULL DEFAULT 0)')
<sqlite3.Cursor object at 0x1048c43b0>
>>> cursor.execute('PRAGMA table_info(demo)')
<sqlite3.Cursor object at 0x1048c43b0>
>>> [r[1] for r in cursor]
[u'foo', u'bar', u'spam', u'eggs']