DELETE VIEW Command

Example   See Also

Deletes a SQL view from the current database.

Syntax

DELETE VIEW ViewName

Arguments

ViewName

Specifies the name of the view deleted from the current database.

Remarks

Use CREATE SQL VIEW to create a SQL view and add the view to the current database. If a SQL view is opened and then deleted, the cursors containing the SQL view results are not closed.

DELETE VIEW requires exclusive use of the database. To open a database for exclusive use, include EXCLUSIVE in OPEN DATABASE.