DROP VIEW Command

JavaScript Editor js editor     Web development 



Main Page

Deletes a SQL view from the current database.

DROP VIEW ViewName

Return Value

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



JavaScript Editor js editor     Web development