ON DELETE CASCADE option

[ashalalaxmi2002]

Can I add ON DELETE CASCADE option to an existing FOREIGN KEY using alter.

[debasisdas]

Yes that can be specified.

[krishnaindia2007]

First you drop the existing constraint.

Alter table drop constraint constraintname;

ex:- alter table drop constraint fk_dept

Then once again add the constraint.

alter table add constraint constraintname foreign key(deptno)
references dept(deptno) on delete cascade

ex:- alter table add constraint dept_emp foreign key(deptno)
references dept(deptno) on delete cascade

[susarlasireesha]

First Drop foreign key constraint using below command
alter table emp drop constraint fk1
After that add fk constraint, cascade option using this command
ALTER TABLE dept
ADD CONSTRAINT fk1
FOREIGN KEY (deptno)
REFERENCES emp(dno) ON DELETE CASCADE;