Condividi tramite


How to: Delete Views

You can delete a view from a database.

To delete a view

  1. Open the application project containing the view in the Project Manager.

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

  3. In the Local Views or Remote Views node, click the view you want to delete, and then Remove.

    Visual FoxPro displays a confirmation dialog box for you to confirm deleting the view.

  4. In the confirmation dialog box, click Remove.

For more information, see Project Manager Window.

To delete a view programmatically

  1. Open the database containing the view.

  2. Use the DELETE VIEW command or DROP VIEW command.

    Note

    These commands perform the same task. DROP VIEW uses the ANSI SQL standard syntax for deleting a SQL view.

For more information, see DELETE VIEW Command and DROP VIEW Command.

See Also

Tasks

How to: Edit Files in Projects
How to: Open Databases

Other Resources

Managing Views
Working with Views (Visual FoxPro)