DROP VIEW Command
TOC
Collapse the table of content
Expand the table of content

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:
© 2016 Microsoft