Is there a way to overcome integrity problems on cascade del

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.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Is there a way to overcome integrity problems on cascade del

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-08-16 : 09:27:25

kalaiselvi writes "Is there a way to overcome integrity problems on cascade delete between multiple tables?

I have

1.Company Table
2.Doctor table
3.Patients Table
4.Address Tables

Address tables stores company address,doctor address,patients address.
Company table and Address table is having parent child relationship with cascade delete.

I need cascade delete for Doctor table and address table and
Patients table and address table.

Any suggestions,Comments are welcome

Thanks in advance"

blindman
Master Smack Fu Yak Hacker

2365 Posts

Posted - 2006-08-16 : 10:03:28

For cases where CASCADE DELETE is not allowed, you can always create ON DELETE triggers on your tables that clean up data in related tables.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources