DROP VIEW Command

  • Article

Deletes a SQL view from the current database.

DROP VIEW ViewName

Property Values

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

Remarks

DROP VIEW is identical to DELETE VIEW; DROP VIEW is the ANSI SQL standard syntax for deleting a SQL view.

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.

See Also

CREATE SQL VIEW | DELETE VIEW | OPEN DATABASE