drop view (core)

Description

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

drop view new_price

This removes the view new_price from the current database.

Usage