Procedure
To prepare a Microsoft SQL Server database
for reuse
- In Microsoft SQL Server Enterprise Manager, connect to the database
for the deleted object store.
- Select the Tables icon in the right
pane.
- 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.
- Click Delete from the menu.
- In the Drop Objects window, click Drop Alll. SQL Server deletes the tables.