syssequences

Provides information about sequence objects used to generate sequential numeric values.

Name	Datatype	Description
id	int	A sequence object ID.
startwith	bigint	The initial value assigned to the sequence when it is created.
minval	bigint	The minimum value to which the sequence can be set.
maxval	bigint	The maximum value to which the sequence can be set.
increment	bigint	The value by which the sequence is incremented each time it is used.
cache	smallint	The cache size setting for the sequence if the caching option is enabled.
status	int	Internal system status information.