How to delete a DEFAULT object (Enterprise Manager)
SQL Server 2000
To delete a DEFAULT object
- Expand a server group, and then expand a server.
- Expand Databases, expand the database in which the DEFAULT object belongs, and then click Defaults.
- In the details pane, right-click the DEFAULT object to delete, and then click Delete.
- To see how deleting this table will affect the database, click Show Dependencies.
- Click Drop All.