The Android platform utilizes the functionality of SQLite databases. This is extremely useful for data driven apps. There is one problem that I came across in developing apps, and that is that SQLite does not allow you to add a primary key column to an existing table.
After looking at this tutorial, I derived a way for adding a primary key column to an existing table by creating two temporary tables, and joining the data back together into the final table.
CREATE TABLE KEYTEMP (ID INTEGER PRI...
Read More