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 ...
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm: