SYSSEQUENCES system tableThe SYSSEQUENCES system table describes the sequence generators in
the database.system tablesSYSSEQUENCESsequence generatorsSYSSEQUENCES system tableSYSSEQUENCES system table
Column NameTypeLengthNullabilityContentsSEQUENCEIDCHAR36FalseThe id of the sequence generator. This is the primary key.SCHEMAIDCHAR36FalseThe id of the schema which holds the sequence generator.
There is a foreign key linking this column to SYS.SYSSCHEMAS.SCHEMAID.SEQUENCENAMEVARCHAR128FalseThe name of the sequence generator. There is a unique index
on (SCHEMAID, SEQUENCENAME).SEQUENCEDATATYPEorg.apache.derby.catalog.TypeDescriptor
This class is not part of the public API.
FalseSystem type that describes the precision, length, scale,
nullability, type name, and storage type of the data.CURRENTVALUEBIGINTTrueThe current value of the sequence generator. The initial
value of this column is STARTVALUE. This column is NULL only if the sequence
generator is exhausted and cannot issue any more numbers.STARTVALUEBIGINTFalseThe initial value of the sequence generator.MINIMUMVALUEBIGINTFalseThe minimum value of the sequence generator.MAXIMUMVALUEBIGINTFalseThe maximum value of the sequence generator.INCREMENTBIGINTFalseThe step size of the sequence generator.CYCLEOPTIONCHAR1FalseIf the sequence generator cycles, this value is 'Y'. If the
sequence generator does not cycle, this value is 'N'.