Skip to main content

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

Image
By User


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, CCNA FINAL EXAM
Labels:

Comments

  1. UserMay 23, 2012 at 9:54 AM

    PRAGMA table_info(table_name);


    will get you a list of all the column names.

    ReplyDelete
  2. UserMay 23, 2012 at 9: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 9: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

Post a Comment

Popular posts from this blog

Slow Android emulator

By User
I have a 2.67 GHz Celeron processor, 1.21 GB of RAM on a x86 Windows XP Professional machine. My understanding is that the Android emulator should start fairly quickly on such a machine, but for me it does not. I have followed all instructions in setting up the IDE, SDKs, JDKs and such and have had some success in staring the emulator quickly but is very particulary. How can I, if possible, fix this problem?
30 comments
Read more

CCNA 3 Final Exam => latest version

By User
1 . Which security protocol or measure would provide the greatest protection for a wireless LAN? WPA2 cloaking SSIDs shared WEP key MAC address filtering   2 . Refer to the exhibit. All trunk links are operational and all VLANs are allowed on all trunk links. An ARP request is sent by computer 5. Which device or devices will receive this message? only computer 4 computer 3 and RTR-A computer 4 and RTR-A computer 1, computer 2, computer 4, and RTR-A computer 1, computer 2, computer 3, computer 4, and RTR-A all of the computers and the router   3 . Refer to the exhibit. Hosts A and B, connected to hub HB1, attempt to transmit a frame at the same time but a collision occurs. Which hosts will receive the collision jamming signal? only hosts A and B only hosts A, B, and C only hosts A, B, C, and D only hosts A, B, C, and E   4 . Refer to the exhibit. Router RA receives a packet with a source address of 192.168.1.65 and a destination address of 192.168.1.161...
20 comments
Read more