Case
SQLDropBehavior.cascade
When the object is referenced from other objects, recursively delete the referencing objects as well.
case cascade
Discussion
Be cautious when using SQLDropBehavior.cascade behavior - any object which blocks the drop in any way will be itself dropped; the cascade recurses as many levels deep as necessary to succeed. This can in some cases result in unexpected data loss if the dependencies between database objects are poorly understood.