Android Sqlite Database: it couldn't recognize the new column or new table I added in an exsiting databse

Question

I had a working database. I just added one more column in a table. It keeps saying no that column. So I changed the table name. Now it says that no that table name. Then I changed the database name. it still gave error. it works fine after I changed back the table name and remove the extra column I added. Could you please help me figure out what's wrong? How do I run my code on a clean emulator? How do I verify that the code that creates the table is getting executed? How do I get the sqlite db off the emualtor and look at it using a sqlite database browser to check that the table does actually exist?

Many thanks! Tong

Answer 1

In real world, you'll have to change database version and migrate changes in onUpgrade(..).
When developing, you can check "Wipe User Data" in Eclipse's run configuration for you project, then close emulator and launch app again.

Answer 2

I found the mistake. I missed the comma after I added the last column. Simple mistake could cost a lot.