Mimer SQL System Management Handbook TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


SEQUENCES


Records sequences in the database.

Column name
Data type
Description

SEQUENCE_SYSID

INTEGER

System identifier of the sequence.

IS_UNIQUE

CHAR(3)

One of:
"YES" = the sequence will yield unique values
"NO" = the sequence may repeat itself.

START_VALUE

INTEGER

The initial value of the sequence.

CURRENT_VALUE

INTEGER

The current value of the sequence.

MAX_VALUE

INTEGER

The maximum value of the sequence.

INCREMENT_VALUE

INTEGER

The increment value of sequence.

IS_EXHAUSTED

CHAR(3)

One of:
"YES" = the series of values defined by the sequence is exhausted
"NO" = the series of values defined by the sequence is not exhausted.

CYCLES

INTEGER

Number of times the maximum value of the sequence is exceeded.

Primary key: SEQUENCE_SYSID



Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL System Management Handbook TOC PREV NEXT INDEX