Top "Cascading-deletes" questions

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

How to DELETE without ON DELETE CASCADE (conflict REFERENCE constraint)

I have a gigantic legacy database with a table that has multiple foreign keys pointing to one other table and …

sql-server tsql cascading-deletes
How to set up cascading deletes in MySQL workbench?

In MySQL Workbench, how do you set up a cascading delete on a relationship? I clicked the relationship line and …

mysql sql cascading-deletes
tsql script to add delete cascade to existing tables

is there a script that can be used to enable cascaded deletion for existing tables. Thanks.

sql sql-server tsql cascade cascading-deletes
Entity Framework: Set Delete Rule with CodeFirst

I am using EF4 CTP 5, CodeFirst. Please see my classes first: public class Guest { [Key] public Guid GuestID { get; set; } …

entity-framework-4 entity-framework-ctp5 cascading-deletes
[MySQL]: DELETE rows from two dependent tables

I am attempting to delete all rows in two dependent tables based on a third tables ID. Table structure: Transaction …

mysql foreign-keys cascading-deletes
How to cascade delete over many to many table

I have a 3 tables that look like this: (source: InsomniacGeek.com) On the foreign keys I have set cascade deletes. …

sql-server cascading-deletes
How to delete automatically all reference rows if parent row get deleted in mysql?

I have a database which contains around 50 tables. Suppose I have a table named parent with id primary key and 24 …

mysql sql parent-child foreign-key-relationship cascading-deletes
Hibernate Cascading Delete Not working as expected

I am using hibernate 3 and attempting to delete a record in the database, and the delete is not working as …

java hibernate cascading-deletes
How to update FK to null when deleting optional related entity

I'm reasonably new to EF, and struggling a little to facilitate deleting my objects. My two objects and associated DbContext …

c# entity-framework ef-code-first cascading-deletes
What is the difference between REMOVE and DELETE?

Is there a difference between : @Cascade(org.hibernate.annotations.CascadeType.REMOVE) and @Cascade(org.hibernate.annotations.CascadeType.DELETE) ?

hibernate annotations cascade cascading-deletes