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