If you have rooted your phone, there are various ways to run these queries but I choose two ways that work for me. These code snippets will assist you in cleaning up your Android contacts. DISCLAIMER: Backup your contacts before you run any of these queries as I take no…
Category: SQLite
Create / Delete SQLite Database Indexes
Source: Billy047 @ http://www.basic4ppc.com/android/forum/threads/dbutils-android-databases-are-now-simple.8475/page-2
Create SQLite Database With Auto Increment
Source: Billy047 @ http://www.basic4ppc.com/android/forum/threads/dbutils-android-databases-are-now-simple.8475/page-2