Use the Confirm Object Deletion dialog to confirm the deletion of various database objects.
When you delete an object, it may affect other objects that depend on the object deleted. For example, if you delete a table that is used in a view definition, you are prompted to specify whether you also want to delete that view definition.
You can specify what actions to take on dependent objects using the following If selected object has dependents options:
Take default action on all dependents: Specifies that the dependent objects will assume the default action for the deleted object.
Delete all dependents: Specifies that the object and all of its dependents will be deleted.
Do not delete selected object: Specifies that if the object has dependents, it will not be deleted.