Deleting a Database

---

PCC includes a Drop (delete) Database Wizard. You can use the wizard to delete a DSN, a Database Name, or an entire database. (You may also delete a database with Table Designer. See Table Designer .)

To delete an Engine DSN, a Database Name, or a complete database from a server, you must have administrative rights on the server.

---

Caution
This procedure is different than removing an engine from the PCC Namespace. This procedure may permanently delete data files and data dictionaries.

---

---

Caution
Do not use the Drop Database Wizard (or the PCC Delete command) to delete DataExchange-enabled databases or DataExchange templates. Use the Deactivation Wizard to remove DataExchange-enabled databases and the Template Remover Wizard to remove templates. The Deactivation Wizard and the Template Remover Wizard can be accessed from the PCC after the Pervasive.DataExchange product is installed.

---

To remove an existing database from an engine

1. In PCC, right-click on the database to be deleted.
2. Select Delete from the shortcut menu. The following dialog box appears:

    
   Figure 3-8 Drop Database Wizard Dialog Box

This dialog provides options to customize how much of the database to remove from the system.

If no options are selected, only the DSN is deleted. The DDFs, database name, and the data files are not affected.

If Delete database name is the only option checked, the DSN and the internal database name are deleted, but the DDFs files and the data files are not affected.

If Delete system files is checked, the DDFs are deleted. You cannot select this option without also selecting Delete database name.

---

Caution
Depending on the options you have selected, deleting a database may erase the related data dictionaries from your hard drive. Do not delete a database unless you are certain you want to do so.

---

3. Click Next. To delete the database, click Finish. To quit without deleting the database, click Cancel.

    
   Figure 3-9 Completing Drop Database Wizard Dialog Box

4. After you click Finish, the wizard displays a final dialog box (not shown) that indicates success. Click Close. At this point the database should disappear from the PCC Namespace. You may need to refresh the screen in the PCC to view this change. To do this, go to the toolbar, click Action, then Refresh.