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

[John Newby]

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.

Many thanks

John