LocalTableatoMfields系统表说明

描述

A pseudo table, similar to GLOBALATOMS, except generated to show only 原子s for fields,只有客户端连接到TE的原子。 (看 Globalatoms系统表描述。)

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.

场地 类型 描述

架构

细绳

SQL架构,其中ATOM的数据库对象驻留。

Tablename.

细绳

与原子相关的表的名称。

对象

整数

识别数据库对象的唯一ID。

桌布一般性

整数

表的数据库目录ID。

场地

细绳

表中字段的名称。

长度

整数

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

精确

整数

The precision specified for a fixed precision numeric, CHAR or BINARY type; the max precision possible for other numeric types

规模

整数

针对固定精度数字类型指定的比例

领域

整数

字段的索引,即左右计数的列数。

LastValidFormatid.

整数

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

索引

没有任何