DROP SEQUENCE

The DROP SEQUENCE statement removes a sequence generator that was created using a  CREATE SEQUENCE statement.

Syntax

DROP SEQUENCE [ schemaName "." ] SQL Identifier RESTRICT

schemaName

The name of the schema to which this sequence belongs. If you do not specify a schema name, the current schema is assumed.

You cannot use a schema name that begins with the SYS. prefix.

SQL Identifier

The name of the sequence.

RESTRICT

This is required. It specifies that if a trigger or view references the sequence generator, Splice Machine will throw an exception.

Usage

Dropping a sequence generator implicitly drops all USAGE privileges that reference it.

Example

splice> DROP SEQUENCE PLAYERID_SEQ RESTRICT;
0 rows inserted/updated/deleted

See Also