Export (0) Print
Expand All
Expand Minimize

How to delete a DEFAULT object (Enterprise Manager)

SQL Server 2000

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

Show:
© 2014 Microsoft