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.
For more information, see DELETE VIEW Command and DROP VIEW Command.