SYS.SEQUENCES

The SEQUENCES table contains all the information about sequences.

Columns

Column name	Type	Description
NAME	TT_CHAR(31) NOT NULL	Sequence name
OWNER	TT_CHAR(31) NOT NULL	Sequence owner
MINVAL	TT_BIGINT NOT NULL	Minimum value
MAXVAL	TT_BIGINT NOT NULL	Maximum value
INCREMENT	TT_BIGINT NOT NULL	Increment value
CACHESIZE	TT_BIGINT NOT NULL	Number of sequence number to be cached For internal TimesTen use.
LASTNUMBER	TT_BIGINT NOT NULL	Last number incremented
UNIQID	TT_BIGINT NOT NULL	Reserved for internal use
SEQID	TT_BIGINT NOT NULL	ID of the sequence row
CYCLE	BINARY(1) NOT NULL	Flag to indicate to wrap around value
IS_REPLICATED	BINARY(1) NOT NULL	Sequence replication status 0 – Sequences are not being replicated. 1 – Sequences are being replicated.
REPACCESS	TT_CHAR(1) NOT NULL	Flag to indicate that sequences cannot be incremented on subscriber-only databases
BATCHSIZE	TT_BIGINT NOT NULL	Not used.
LASTBATCHNUMBER	TT_BGINT NOT NULL	Unused. Column unused by TimesTen. Ignore value.
GLOBALLASTBATCHNUMBER	TT_BIGINT NOT NULL	Unused. Column unused by TimesTen. Ignore value.