Skip to main content

How to get a list of column names on Sqlite3 database?

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?

luebken
  • 7k
  • 5
  • 24
  • 18