NAME

DROP VIEW - 刪除一個視圖

SYNOPSIS

DROP VIEW name [, ...] [ CASCADE | RESTRICT ]

DESCRIPTION 描述

DROP VIEW 從數據庫中刪除一個現存的視圖。 執行這條命令必須是視圖的所有者。  

PARAMETERS 參數

name

 要刪除的視圖名稱（可以有模式修飾）。

CASCADE

 自動刪除依賴此視圖的對象（比如其它視圖）。

RESTRICT

 如果有依賴對象存在，則拒絕刪除此視圖。這個是缺省。

EXAMPLES 例子

 下面命令將刪除視圖 kinds：

DROP VIEW kinds;

COMPATIBILITY 兼容性

 這條命令遵循 SQL 標準。  

SEE ALSO 參見

CREATE VIEW [create_view(7)]

#p#

NAME

DROP VIEW - remove a view

SYNOPSIS

DROP VIEW name [, ...] [ CASCADE | RESTRICT ]

DESCRIPTION

DROP VIEW drops an existing view. To execute this command you must be the owner of the view.  

PARAMETERS

name

The name (optionally schema-qualified) of the view to remove.

CASCADE

Automatically drop objects that depend on the view (such as other views).

RESTRICT

Refuse to drop the view if any objects depend on it. This is the default.

EXAMPLES

This command will remove the view called kinds:

DROP VIEW kinds;

COMPATIBILITY

This command conforms to the SQL standard.  

SEE ALSO

CREATE VIEW [create_view(7)]