Android Tutorial Get rid of faulty row in table SQLite_Master

After running some faulty code I ended up with a faulty entry in the SQLite SQLite_Master table.
This was a table name called NON_CLINICAL.db.JOURNEYS. This name is faulty and was causing
all sorts of problems. Note that is not a table name that is accessible with normal SQL.
Now it is not that easy to get rid of this faulty row in SQLite_Master, but this simple SQL did the trick:

drop table "NON_CLINICAL.db.JOURNEYS"

Note the double quotes around the faulty table name.
This got rid of that faulty entry and solved all the problems.

RBS
 
Cookies are required to use this site. You must accept them to continue using the site. Learn more…