I know it is an old thread, but recently I needed the same and found a neat way:
SELECT c.name FROM pragma_table_info('your_table_name') c; 3 of 3
Wasteful complicated query. I made it simplest one according to the question.
S.M.Mousavi
- 5.3k
- 7
- 48
- 64
Slavian Petrov
- 662
- 5
- 7