Sequence
class Sequence(val name: String, val startWith: Long? = null, val incrementBy: Long? = null, val minValue: Long? = null, val maxValue: Long? = null, val cycle: Boolean? = null, val cache: Long? = null)
Represents a database sequence.
Parameters
name
Name of the sequence.
start
Beginning of the sequence.
increment
Value to be added to the current sequence value when creating a new value.
min
Minimum value a sequence can generate.
max
Maximum value for the sequence.
cycle
Allows the sequence to wrap around when the maxValue or minValue has been reached by an ascending or descending sequence respectively.
cache
Specifies how many sequence numbers are to be pre-allocated and stored in memory for faster access.
Constructors
Properties
Functions
Link copied to clipboard
Returns the SQL statements that create this sequence.
Link copied to clipboard
Returns the SQL statements that drop this sequence.
Link copied to clipboard
Advances this sequence and returns the new value.
Link copied to clipboard
Advances this sequence and returns the new value.