-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 12/03/12 14:42, Alessio Forconi wrote: > I am a novice with SQLite and I wonder if there is a select that > returns the names of the fields in the table?
You most likely want pragma table_info: http://www.sqlite.org/pragma.html#pragma_table_info If you have a SELECT then you can see what the associated names for each column of the result are by using sqlite3_column_name: http://www.sqlite.org/c3ref/column_name.html Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAk9ebw4ACgkQmOOfHg372QT26QCg1xAarj3w+VlOC6mVJECB22tP WugAoJvHsA12DNPEtEw5I713efjRpxoB =Y8Gn -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users