Drop Sequence
- Last Updated: May 15, 2020
- 1 minute read
- DataDirect Connectors
- JDBC
- IBM Db2 5.1
- MySQL 5.1
- Progress OpenEdge 5.1
- SAP Sybase 5.1
- Documentation
Purpose
Drops a sequence for a local table.
Syntax
DROP SEQUENCE sequence_name [IF EXISTS] [RESTRICT|CASCADE]
where:
- sequence_name
- specifies the name of a sequence to drop.
- IF EXISTS
- specifies that an error is not to be returned if the sequence does not exist.
- RESTRICT
- is in effect by default, meaning that the drop fails if any view refers to the sequence.
- CASCADE
- silently drops all dependent database objects.