SQLite Forum

Have you tried,

>PRAGMA table_info(tablename);

that is how I grab all of my columns names from a table.

```
sqlite> PRAGMA table_info(Business_OBS_List);
0|Bus_OBS||0||1
1|Bus_Area||0||0
2|Bus_Org||0||0
```

Maybe I am misunderstanding your question.