system.tables

Advantage SQL Engine

Contains one row for each table in the database.

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

Integer

4

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

Integer

4

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

Table_Memo_Block_Size

Integer

4

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

Table_Validation_Expr

Memo

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.