Name
sequence_remove — Removes a sequence object
Synopsis
sequence_remove ( |
in name varchar ); |
Description
The function removes a sequence object created before by
sequence_set or sequence_next .
Parameters
name
The name of the sequence object to be deleted.
Return Types
The function returns integer one if the sequence object is removed, zero if there was no object with the specified name.
Examples
Example24.367.Creation and Removal of a Sequence Object
This sequence of operations demonstrates how sequence_remove reverts the effect of
sequence_next .
> select sequence_next ('my_sequence');
0
> select sequence_next ('my_sequence');
1
> select sequence_next ('my_sequence');
2
> select sequence_remove ('my_sequence');
1
> select sequence_next ('my_sequence');
0