Re: [sqlite] Query for ON_DELETE_CASCADE

On Tue, Jun 14, 2005 at 09:54:26AM +0530, Ajay wrote: > There are 3 tables interconnected with each other by foreign keys. On > deleting particular item from one table should delete all items from other > tables that was pointing to it using foreign key (Just like > ON_DELETE_CASCADE - SQLite does

[sqlite] Query for ON_DELETE_CASCADE

Hello All, There are 3 tables interconnected with each other by foreign keys. On deleting particular item from one table should delete all items from other tables that was pointing to it using foreign key (Just like ON_DELETE_CASCADE - SQLite does not support ON_DELETE_CASCADE, so I want to write