sqlite get columns for table
sqlite3 path/to/db.sqlite sqlite> .schema
Source: stackoverflow.com
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
Source: stackoverflow.com