View Single Post
Old April 30th, 2009, 06:00 PM
yevi yevi is offline
Authorized User
Join Date: Mar 2009
Posts: 75
Thanks: 16
Thanked 1 Time in 1 Post
Default Relationships between the Tables - Delete rule

Is it wise to set relationship between Categories and Articles tables Delete rule = cascade?

I think that with this dangerous operation by mistakenly deleting a category (even confirming the delete operation) will result a deletion of all articles in a category.

Maybe it's better to cascade to a default value like "Uncategorized"?
And also to add one or 2 SPs for deleting category and all alrticles by demand.
This will of course lower the performance but will increase capabilities.