So this should be a really easy one, but i've spent a few hours searching and can't find anything that explicitly states how to do this. All i want to do is see the column names for a particular table. I created the tables like:
con = sqlite3.connect( ":memory:" ) cur = con.cursor() cur.execute( "CREATE TABLE tablename ( d1 varchar, d2, varchar )" ) cur.execute( "INSERT INTO tablename values (?,?)", tuple(datarow) )
since the tables are created dynamically i want be able to see the column headers; 'd1' and 'd2' in this case. isn't there an easy way to do this???
Thanks in advance.