Re: [sqlite] How do you find out the names of the fields within a table?

[Christian Smith]

John Newby uttered:

Hi, how can I find out the names of the fields within a given table?
I've tried "pragma table_info(test);"

but this brings back too much info, I just require the names as I'll be
storing them in an array within my application.


Then just cherry pick the information you require. You get a result set 
from the pragma, and the column name is the second field. Not difficult.



Many thanks

John


--
    /"\
    \ /    ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL
     X                           - AGAINST MS ATTACHMENTS
    / \