How to: Remove Databases from Projects

You can remove a database from a project or delete it from disk permanently. Removing a database does not automatically delete the database. Deleting the database using the steps described makes it possible for Visual FoxPro to remove the back link information in the database tables.

Note

Using other methods such as searching for the database files and deleting them using Windows Explorer does not remove back link information.

To remove or delete a database from a project

1. Open the project in the Project Manager Window.

2. In the Project Manager, expand the Data node, then the Databases node.

3. Click the database you want to remove, and then Remove.

   Visual FoxPro prompts you to remove the database from the project or delete it from disk.

4. In the confirmation dialog box, perform one of the following:

   • To remove the database from the project, click Remove.

   -OR-

   • To delete the database from disk, click Delete.

To delete a database programmatically

• Use the DELETE DATABASE command.

  Note

  DELETE DATABASE does not delete database tables from disk. Instead, database tables become free tables.

  Tip

  To delete a database and its associated tables from disk, use the DELETE DATABASE command with the DELETETABLES clause.

For more information, see DELETE DATABASE Command.

For example, the following code deletes a database named MyDatabase from disk:

DELETE DATABASE MyDatabase

See Also

Other Resources

Creating Databases

Managing Databases