NAME

DROP SEQUENCE - 刪除一個(gè)序列

SYNOPSIS

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

DESCRIPTION 描述

DROP SEQUENCE 從數(shù)據(jù)庫(kù)中刪除序列號(hào)生成器。  

PARAMETERS 參數(shù)

name

 序列名（可以有模式修飾）。

CASCADE

 自動(dòng)刪除依賴序列的對(duì)象。

RESTRICT

 如果存在任何依賴的對(duì)象，則拒絕刪除序列。這個(gè)是缺省。

EXAMPLES 例子

 從數(shù)據(jù)庫(kù)中刪除序列 serial：

DROP SEQUENCE serial;

COMPATIBILITY 兼容性

 在 SQL 標(biāo)準(zhǔn)里沒(méi)有 DROP SEQUENCE。  

SEE ALSO 參見(jiàn)

CREATE SEQUENCE [create_sequence(7)]

#p#

NAME

DROP SEQUENCE - remove a sequence

SYNOPSIS

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

DESCRIPTION

DROP SEQUENCE removes sequence number generators.  

PARAMETERS

name

The name (optionally schema-qualified) of a sequence.

CASCADE

Automatically drop objects that depend on the sequence.

RESTRICT

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

EXAMPLES

To remove the sequence serial:

DROP SEQUENCE serial;

COMPATIBILITY

There is no DROP SEQUENCE statement in the SQL standard.  

SEE ALSO

CREATE SEQUENCE [create_sequence(7)]