LOCALATOMSEQUENCES System Table Description


A pseudo table generated for internal debugging purposes only. This table does not provide much information for users. It contains information about a NuoDB atomThe internal object structure representing all data in a NuoDB database. Atoms are self-coordinating objects that represent specific types of information (such as data, indexes or schemas).s used in sequences.

Caution: Client applications should never contain code that accesses SYSTEM pseudo tables as they are subject to, and furthermore likely to, change from release to release.


Field Type Description
SCHEMA string The schema in which the sequence was created
SEQUENCENAME string The sequence name
CATALOGID integer The catalog ID for the sequence
OBJECTID integer The ID for the sequence
NEXTVALUE bigint The next value in the sequence

Caution: Doing a query on the SYSTEM.LOCALATOMSEQUENCES will increment the sequence value.