Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rkpamidi
Starting Member
5 Posts |
 Posted - 2001-07-14 : 08:18:27
|
| We are unable to delete data from Master table which has got foreignkey relationship in other child tables as it violates the referentialintegrity constraint.we tried to delete the corresponding data in child tables using a Triggerbut the referential constraint is checked first and we are unable to deletethe data in the Master table.There is no provision in SQLSERVER for CASCADING the delete from theMaster table.Can anyone suggest a solution at the earliest? |
|
|
|
|
|
Problem Deleting data from Master table with Fore