LOCALTABLEATOMFIELDS System Table Description
Description
A pseudo table, similar to GLOBALATOMS, except generated to show only atoms for fields, and only those atoms local to the Transaction Engine (TE) to which the client is connected. (See GLOBALATOMS System Table Description.)
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.
|
Fields
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 |
bigint |
A unique ID identifying the database object. |
TABLECATALOGID |
bigint |
The database catalog ID for the table. |
FIELD |
string |
The name of the field in the table. |
TYPE |
integer |
Integer from ID in SYSTEM.DATATYPES for the data type of the field. |
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 |