Search code examples
iphonecocoa-touchios4sqlite

iPhone : Where can we get the information of index created in Sqlite table?

In my iPhone app, I have created index on Sqlite database table for some columns.

Now I want to look at the indexes I created.

Where will I be able to look at the indexes? What should I do?

Solution

  • In Terminal, you can open the database with:

    sqlite3 my_database.sqlite

    In the SQLite3 app, .tables will give you a list of all tables in your database and .indices TABLENAME will list all indexes for a given table.

    You can also use any other SQLite GUI app that is capable of showing you your indexes.