[sqlite] ON_DELETE_CASCADE constraint is not working

[Ajay]

Hello there,

I have two tables and used constraint ON_DELETE_CASCADE in one of the table
to delete records from second table if records from first table are deleted
which foreign key points to first table. I'm using SQLiteExplorer to
manipulate tables. But it is not working properly. I found all records of
first table as it is though record of foreign key is deleted from second
table.

Let me know solution.

 

Regards,

Ajay Sonawane