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. |