mercredi 24 février 2016

Droping Referencing and Referenced tables in SQLite

Working with the artist/tracks example at http://ift.tt/1eCkxPY

I'd like to drop both tables. I would think that if I first drop tracks (which References artist) I could then drop artists:

stat_5.executeUpdate("drop table if exists tracks;"); stat_6.executeUpdate("drop table if exists artist;");

But this issues an exception "SQLException: foreign key constraint failed"

What am I missing?

Thanks in advance.

Ed

Aucun commentaire:

Enregistrer un commentaire