Top "Cascading-deletes" questions

The concept of SQL databases deleting rows that refer (via a foreign key) to a deleted row.

Trigger calls in cascade deleting

I have table "A" in MySQL. It has some references with cascade deleting to some other tables ("B", "C", "D" ...). …

mysql triggers cascade cascading-deletes
Error PostgreSQL delete with INNER JOIN

Postgres 8.4 DELETE FROM processing_transaction AS pt INNER JOIN processing_transaction_movement AS ptm ON pt.processing_transaction_id = ptm.…

sql postgresql sql-delete cascading-deletes
EF4.1 Code First : How to disable delete cascade for a relationship without navigation property in dependent entity

Let's say I have these two very basic entities: public class ParentEntity { public int Id; public virtual ICollection<ChildEntity&…

c# entity-framework ef-code-first foreign-keys cascading-deletes
Cascade deleting from join table with @ManyToMany annotation

Hi I got a problem with mapping my entities. I'm using JPA2 and Hibernate implementation. I got tables with @ManyToMany …

hibernate annotations jpa-2.0 cascade cascading-deletes
Hibernate delete objects on cascade

I'm sligthly confused as to how the cascade="delete" works. I defined the mapping in the following way in the …

java hibernate orm cascading-deletes
Cascade Delete Rule in EF 4.1 Code First when using Shared Primary Key Association

I implemented a bidirectional 1:1 relationship based on this answer: Primary /Foreign Key in Entity Framework I define the bidirectional relation …

ef-code-first sql-server-ce entity-framework-4.1 cascade cascading-deletes
How do I delete a child entity from a parent collection with Entity Framework 4?

I'm using Entity Framework 4 and have a one-to-many relationship between a parent and child entity. I'm trying to delete a …

entity-framework cascading-deletes
Core Data Relationships cause save error after delete

This question is probably a long shot. I can't figure out the errors I'm getting on my core data project …

core-data cascading-deletes
ALTER TABLE to add ON DELETE CASCADE statement

I want to do the following in PostgreSQL (using Hibernate): ALTER TABLE fruits ADD CONSTRAINTS id ON DELETE CASCADE; Obviously, …

hibernate postgresql cascade cascading-deletes postgresql-9.0
Figure out if a table has a DELETE on CASCADE

Can I know if a database have DELETE ON CASCADE with a query?

mysql database cascading-deletes