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 form to access the Key table.
