Shaun
Reputation: 2181
How to check if index includes a particular column in SQLite
I want my app to add a column to an existing index if that column hasn't already been added to the index.
Is there a way to test if the column exists in the index, or am I better off dropping and rebuilding the entire index including the new column?
Cheers guys.
Upvotes: 1
Views: 90
Answers (1)
CL.
Reputation: 180070
To get information about the columns in an index, use PRAGMA index_info.
Upvotes: 1
Related Questions
- Check if a column exists in SQLite
- How do I get the indexed columns of a table in SQLite database
- sqlite determine if index is used
- Verify if an index exists in a Sqlite table
- SQLite identify missing index
- How can I find out if an index has been created on a SQLite table?
- sqlite: "no query solution" for covering index when column != "something"
- Is there a way to tell what columns an SQLite internal index is on?
- SQLite. Conditional search checking for column value existance
- How can I tell if a column in my sqlite3 RoR database has a database index on it?