How can I get the list of a columns in a table for a SQLite database?
What you’re looking for is called the data dictionary. In sqlite a list of all tables can be found by querying sqlite_master table (or view?) sqlite> create table people (first_name varchar, last_name varchar, email_address varchar); sqlite> select * from sqlite_master; table|people|people|2|CREATE TABLE people (first_name varchar, last_name varchar, email_address varchar) To get column information you can … Read more