Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
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:
© 2015 Microsoft