Export (0) Print
Expand All
Expand Minimize

DROP VIEW Command

Deletes a SQL view from the current database.


DROP VIEW ViewName

ViewName

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

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.

Community Additions

ADD
Show:
© 2014 Microsoft