NAME

DROP VIEW - 刪除一個(gè)視圖

SYNOPSIS

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

DESCRIPTION 描述

DROP VIEW 從數(shù)據(jù)庫中刪除一個(gè)現(xiàn)存的視圖。 執(zhí)行這條命令必須是視圖的所有者。  

PARAMETERS 參數(shù)

name

 要?jiǎng)h除的視圖名稱（可以有模式修飾）。

CASCADE

 自動(dòng)刪除依賴此視圖的對(duì)象（比如其它視圖）。

RESTRICT

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

EXAMPLES 例子

 下面命令將刪除視圖 kinds：

DROP VIEW kinds;

COMPATIBILITY 兼容性

 這條命令遵循 SQL 標(biāo)準(zhǔn)。  

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)]