Appendix D: Using Sybase Mode Commands

drop view (core)

Removes one or more views from the current database.

Transact-SQL Syntax

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

ODBC Syntax

DROP VIEW viewed_table_name
[CASCADE|RESTRICT]

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

drop view new_price

This removes the view new_price from the current database.

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 to be used in the statement. Since 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.