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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-01-08 : 08:03:14
|
| Prasad writes "I have two tables which have a foreign key relationship between them. While deleting a record in the master table it gives an error. However, if we give 'CASCADE DELETE'; it is deleting the child record without any alert message. I need to have an alert message or an error message saying deletion is not possible because there is a child record referencing the parent table." |
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2004-01-08 : 08:22:41
|
| One option would be an INSTEAD OF DELETE trigger |
 |
|
|
|
|
|
Delete a record in master table