CODE EXAMPLE FOR SQL

sqlite get columns for table

sqlite> pragma table_info(people);
0|first_name|varchar|0||0
1|last_name|varchar|0||0
2|email_address|varchar|0||0