Re: [sqlite] SELECT that returns the name of the fields

2012-03-13 Thread Alessio Forconi
Thank you, pragma is perfect! Alessio Forconi Il 12/03/12 22:47, Roger Binns ha scritto: -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?

[sqlite] SELECT that returns the name of the fields

2012-03-12 Thread Alessio Forconi
Hi all, I am a novice with SQLite and I wonder if there is a select that returns the names of the fields in the table? Thanks and sorry for my bad English -- Alessio Forconi ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] SELECT that returns the name of the fields

2012-03-12 Thread Roger Binns
-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