How to get a list of column names on Sqlite3 database?
database, database-table, select, sql, sqlite
Solution
PRAGMA table_info(table_name);
will get you a list of all the column names.
Problem
I want to migrate my iPhone app to a new database version. Since I don't have some version saved, I need to check if certain column names exist. This Stackoverflow entry suggests doing the select ``` SELECT sql FROM sqlite_master WHERE tbl_name = 'table_name' AND type = 'table' ``` and parse the result. Is that the common way? Alternatives?