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
 
Top