drop view (core)

Removes one or more views from the current database.

Syntax

Transact-SQL Syntax

drop view [owner.]view_name[,[owner.]view_name]...

ODBC Syntax

DROP VIEW viewed_table_name
[CASCADE|RESTRICT]

Parameters

view_name – is the name of the view to be dropped. The name must be a legal identifier and cannot include a database name.

Examples

Example 1 – removes the view new_price from the current database.
```
drop view new_price
```

Usage

Transact-SQL allows you to drop multiple views in one statement, but ODBC does not. If multiple views are encountered, transformation generates multiple DROP statements.
ODBC allows the keywords CASCADE and RESTRICT in the statement. Because Transact-SQL does not support this, these keywords are not generated during transformation.
Each time a view is referenced, another view or stored procedure checks the existence of the view.

Parent topic: Transact-SQL Commands

Created November 29, 2012. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com