demonfox (3/20/2013)

---

Danny Ocean (3/20/2013)

---

Good question.

In real life scenario, we need to take care of cascade option.

I prefer not to have delete cascade on design .. to let the error display when the constraint doesn't allow it..

well, delete cascase could be a better option for delete based on performance , but with proper indexing , I guess, basic deletes shouldn't be too intensive process ..

and , it keeps of mistakes off the track 🙂 that's what constraints are for ...