A pseudo table, similar to GLOBALATOMS, except generated to show only atomThe internal object structure representing all data and metadata in a NuoDB database. Atoms are self-coordinating objects that represent specific types of information (such as data, indexes, or schemas). Atoms are stored in memory on both TEs and SMs or serialized over the network and stored to disk by SMs. See also Storage Manager (SM).s for fields, and only those atoms local to the TE to which the client is connected. (See GLOBALATOMS System Table Description.)

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.


Like SYSTEM.GLOBALATOMS, most fields in LOCALTABLEATOMFIELDS are not of much interest to the user. Here are a few exceptions.

Field Type Description
SCHEMA string The SQL schema in which the database object for the atom resides.
TABLENAME string The name of the table associated with the atom.
OBJECTID integer A unique ID identifying the database object.
TABLECATALOGID integer The database catalog ID for the table.
FIELD string The name of the field in the table.
LENGTH integer Length associated with the data type - this is the precision assigned to a CHAR or BINARY type or the size in bytes of the type
PRECISION integer The precision specified for a fixed precision numeric, CHAR or BINARY type; the max precision possible for other numeric types
SCALE integer The scale specified for a fixed precision numeric type
FIELDID integer Index of the field, that is, the column number counting left to right.
LASTVALIDFORMATID integer As a table has fields added or removed, its format ID increments. If LASTVALIDFORMATID is 0, it means the field is valid. If it is non-zero, it is the last table format ID for which is valid. So if a field is removed on a table with format ID 5, then LASTVALIDFORMATID will be 5