Add ON DELETE CASCADE
hi every body.
i want to add the constraint "ON DELETE CASCADE" on foreign key value in child table like.
ALTER table employee
Add CONSTRAINT cscade_dept_no ON DELETE CASCADE (Deptno)
but it display error message, so please help me in this regards.
Thanks
Edited by: BilalKhan on Feb 7, 2011 11:53 PM