ON DELETE CASCADE with referenced column

Is it possible to delete all rows pointing to a reference that I am deleting ?
I have a Catalogs and Pages tables,
and I would like if I remove a catalog, it would delete all the pages related to it.
and not just making the reference as “Empty” for the Pages with the Catalog just deleted .


1 Like

Hi Sao,

That would be a neat feature! For now, the best thing I can recommend is filtering the Pages table to only show records referencing the Catalog to be deleted. Select all those records and delete them, then delete the catalog record you’d like to remove.

1 Like