mardi 19 mai 2015

Deleting a table linked to another(with foreign key constraint)in sqlite

I have 2 sqlite table as follow:

CREATE TABLE test
(id integer primary key);

CREATE TABLE test2
(id integer primary key
foreign key (id) references test(id) );

I want to delete the 'test' table without deleting the test2 table.And im not quite sure on how to do that.In sqlite.

thank you

Aucun commentaire:

Enregistrer un commentaire