How to delete a DEFAULT object (Enterprise Manager)

How to delete a DEFAULT object (Enterprise Manager)

To delete a DEFAULT object

1. Expand a server group, and then expand a server.
   
   
2. Expand Databases, expand the database in which the DEFAULT object belongs, and then click Defaults.
   
   
3. In the details pane, right-click the DEFAULT object to delete, and then click Delete.
   
   
4. To see how deleting this table will affect the database, click Show Dependencies.
   
   
5. Click Drop All.

See Also

Creating and Modifying DEFAULT Definitions