posted 19 years ago
I will recommend to have one additional column as enable/disable flag, and whenever you dont need record simple disable them(Soft delete)
otherwise you can delete them by cascading constraints, I do this in oracle somtimes but NOT recommended.
what about child record ? dont you want to delete them ?
Gravitation cannot be held responsible for people falling in love ~ Albert Einstein