Open topic with navigation
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.
SYSTEM.GLOBALATOMS, most fields in
LOCALTABLEATOMFIELDS are not of much interest to the user. Here are a few exceptions.
|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
|PRECISION||integer||The precision specified for a fixed precision numeric,
|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