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.