Navigation:  Advantage SQL > System Views > Views >

system.ansi_tables

Advantage SQL Engine

Previous pageReturn to chapter overviewNext page

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

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.

Table_Primary_Key

Character

128

Name of the table’s primary key.

Table_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

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.

Triggers_Disabled

Logical

1

Flag indicating if triggers are disabled on this table.

Table_Caching

ShortInt

2

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

 

Table_Trans_Free

Logical

1

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

 

Table_WEB_Delta

Logical

1

Flag indicating if Web Service Delta Support is enabled on this table.

Table_Concurrency_Enabled

Logical

1

Flag indicating if optimistic concurrency control is enabled on this table.