Product Documentation

SQL Reference Guide

Previous Topic

Next Topic

DROP SEQUENCE

Syntax

DROP SEQUENCE sequence_name

Description

The DROP SEQUENCE command deletes the specified sequence.

  • sequence_name is the name of the sequence that is to be deleted.

Example

To delete the sequence myseq, enter:

DROP SEQUENCE myseq ;

Return Values

Error Code

Message

Returned By

-20266

Sequence cannot be used here

DROP SEQUENCE
ALTER SEQUENCE

-20267

Sequence not found

DROP SEQUENCE
ALTER SEQUENCE

See c-tree Plus Error Codes for a complete listing of valid c-tree Plus error values.

See Also

TOCIndex