Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.