Field Name

Field Type

Field Size

Description

Name

Character

200

Name of the table object in the data dictionary.

Table_Relative_Path

Character

260

The relative path to the table including the table name.

Table_Type

ShortInt

2

Numeric value representing the table type.

1 = ADS_NTX

2 = ADS_CDX

3 = ADS_ADT

4 = ADS_VFP

Table_Auto_Create

Logical

1

Determines if the table and associated indexes are automatically created if they do not exist.

Primary_Key

Character

128

Name of the table’s primary key.

Default_Index

Character

128

Name of the table’s default index.

Table_Encryption

Logical

1

Determines if the table is encrypted.

Table_Permission_Level

ShortInt

2

Determines how the column level permissions on the table are enforced.

Table_Memo_Block_Size

ShortInt

2

The size of the memo block used when auto-creating a table.

Table_Validation_Expr

NMemo

variable

Table level validation expression for newly inserted records.

Table_Validation_Msg

Memo

variable

Custom error message displayed to the user when the table validation method fails.

Comment

Memo

variable

Description of the Table.

User_Defined_Prop

Binary

variable

The user defined property.

Table_Caching

ShortInt

2

Specifies table data caching level.  Please see Table Data Caching before enabling this feature.  Value is expected to be 1 (CACHE_READS), 2 (CACHE_WRITES), or 0 (CACHE_NONE).

Table_Trans_Free

Logical

1

Specifies whether the table is a transaction-free table that is excluded from all active transactions.