Wednesday, May 23, 2012

How to get a list of column names on sqlite3 / iPhone?


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?


Source: Tips4all
Post by On
Tags , , ,

3 comments:

  1. UserMay 23, 2012 at 2:53 AM

    PRAGMA table_info(table_name);


    will get you a list of all the column names.

    ReplyDelete
  2. UserMay 23, 2012 at 2:54 AM

    If you have the sqlite database, use the sqlite3 command line program and the commands:
    .tables - to list all the tables in the database
    .schema tablename - to show the schema for the given table

    ReplyDelete
  3. UserMay 23, 2012 at 2:54 AM

    you can use Like statement if you are searching for any particular column

    ex:

    SELECT * FROM sqlite_master where sql like('%LAST%')

    ReplyDelete

Subscribe to: Post Comments (Atom)