Adding a Primary Key Column in SQLite

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