NAME

DROP SEQUENCE - 刪除一個序列

SYNOPSIS

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

DESCRIPTION 描述

DROP SEQUENCE 從數據庫中刪除序列號生成器。  

PARAMETERS 參數

name

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

CASCADE

 自動刪除依賴序列的對象。

RESTRICT

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

EXAMPLES 例子

 從數據庫中刪除序列 serial：

DROP SEQUENCE serial;

COMPATIBILITY 兼容性

 在 SQL 標準里沒有 DROP SEQUENCE。  

SEE ALSO 參見

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