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?

Related Posts:

  1. How can I add the sqlite3 module to Python?
  2. sqlite3 “foreign key constraint failed”
  3. How do I unlock a SQLite database?
  4. Creating stored procedure and SQLite?
  5. SQLITE, Create a temp table then select from it
  6. File extension .DB – What kind of database is it exactly?
  7. How to use SQLite in Visual Studio 2017?
  8. Where does Chrome keep the SQLite Database file it writes things like stored passwords to?
  9. How to open .SQLite files
  10. SQLite – UPSERT *not* INSERT or REPLACE
  11. Is there an SQLite equivalent to MySQL’s DESCRIBE [table]?
  12. SQLiteDatabase.query method
  13. Django – no such table exception
  14. Exit a SQLite 3 database
  15. Sqlite3, OperationalError: unable to open database file
  16. Django – no such table exception
  17. sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 1, and there are 74 supplied
  18. “Insert if not exists” statement in SQLite
  19. Error: C2228: left of ” must have class/struct/union
  20. What is difference between SQLite and SQL
  21. java.lang.ClassNotFoundException: org.sqlite.JDBC error in Sample.java program from xerial
  22. Convert MySQL to SQlite [closed]
  23. sqlite3.OperationalError: unable to open database file
  24. OperationalError: database is locked
  25. SQLite equivalent to ISNULL(), NVL(), IFNULL() or COALESCE()
  26. Sqlite: CURRENT_TIMESTAMP is in GMT, not the timezone of the machine
  27. SQLite string contains other string query
  28. Why do I get sqlite error, “unable to open database file”?

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)