remove ON DELETE CASCADE

sql constraints cascade alter
Raghav picture Raghav · Oct 28, 2014 · Viewed 10.6k times · Source

I have a child table. and foreign key there with ON DELETE CASCADE while creating the table.

There are no records either in child or parent table.

I want the primary key, foreign key to be as they are but want to remove only the CASCADING option from the child table .

is there anyway that i can Alter that child table.

Thank you.

Answer

knkarthick24 picture knkarthick24 · Oct 28, 2014 
ON DELETE { NO ACTION | CASCADE | SET NULL | SET DEFAULT }

The default is NO ACTION.

So try altering your child table back to default.

Related questions

SQL Server - Cascading DELETE with Recursive Foreign Keys

I've spent a good amount of time trying to figure out how to implement a CASCADE ON DELETE for recursive primary keys on SQL Server for some time now. I've read about triggers, creating temporary tables, etc but have yet …

Read More
Add primary key to existing table

I have an existing table called Persion. In this table I have 5 columns: persionId Pname PMid Pdescription Pamt When I created this table, I set PersionId and Pname as the primary key. I now want to include one more column …

Read More
Display names of all constraints for a table in Oracle SQL

I have defined a name for each of the constraint for the multiple tables that I have created in Oracle SQL. The problem is that to drop a constraint for the column of a particular table I need to know …

Read More