SYS.SEQUENCES

The SEQUENCES table contains all the information about sequences. Data from the system table is restored to the new data store during a CREATE SEQUENCE statement.

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.
SEQID	TT_INTEGER NOT NULL on 32-bit systems; TT_BIGINT NOT NULL on 64-bit systems	ID of the sequence row
CYCLE	BINARY (1) NOT NULL	Flag to indicate to wrap around value.
IS_REPLICATED	BINARY (1) NOT NULL	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 data stores.