You can delete a view from a database.
To delete a view
Open the application project containing the view in the Project Manager.
In the Project Manager, expand the Data node, and then the Databases node.
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.
In the confirmation dialog box, click Remove.
For more information, see Project Manager Window.
To delete a view programmatically
Open the database containing the view.
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.