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.
The ID number for the table.
The number of the key.
The name of the table.
The fields that make up the key.
The SumIndexFields that are defined for this key.
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.
Whether the index is enabled. This field can be modified.
Whether the MaintainSQLIndex property has been activated. This field can be modified.
Whether the MaintainSIFTIndex property has been activated. This field can be modified.
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.