Export (0) Print
Expand All
Expand Minimize

DROP VIEW Command

Visual Studio .NET 2003

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

Show:
© 2014 Microsoft