Preparing databases for reuse (Microsoft SQL Server)

Procedure

To prepare a Microsoft SQL Server database for reuse

  1. In Microsoft SQL Server Enterprise Manager, connect to the database for the deleted object store.
  2. Select the Tables icon in the right pane.
  3. Select and right-click all the user tables in the right pane. The user tables are identified by the term User in the Type column.
  4. Click Delete from the menu.
  5. In the Drop Objects window, click Drop Alll. SQL Server deletes the tables.