JavaScript Editor js editor     Web development 



Main Page

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:

В Copy Code
DELETE DATABASE MyDatabase

See Also



JavaScript Editor js editor     Web development