The Key virtual table contains information about the keys that are defined in each table in the database.

The Key virtual table contains the following fields.

Field Description

TableNo

The ID number for the table.

No.

The number of the key.

TableName

The name of the table.

Key

The fields that make up the key.

SumIndexField

The SumIndexFields that are defined for this key.

SQLIndex

The actual fields that have been defined in Microsoft Dynamics NAV and are used in the corresponding index on SQL Server instead of those defined in the key.

Enabled

Whether the index is enabled. This field can be modified.

MaintainSQLIndex

Whether the MaintainSQLIndex property has been activated. This field can be modified.

MaintainSIFTIndex

Whether the MaintainSIFTIndex property has been activated. This field can be modified.

Clustered

Whether the key is clustered. This field can be modified.

You must create a tabular-type page to access the Key table. The following illustration shows the Key virtual table.

Key Virtual table

See Also