The keys associated with a table have properties that describe their behavior, just as tables and fields do. When you create a key, C/SIDE automatically suggests a number of default values for these properties. Depending on the purpose of the key, you will sometimes want to change these default values.
C/SIDE contains the following properties for keys.
Property Name | Use |
---|---|
Determines whether the system will maintain an index for the key. You cannot use a key unless it is enabled. |
|
Defines the key. |
|
Determines the fields for which the system will maintain a SumIndex. |
|
Determines which key groups the key is a member of. By making the key a member of a predefined key group you can have the key defined and only enable it when it is going to be used. |
|
Checks if any errors occurred the last time you restored a backup. |
|
Determines whether a SQL Server index corresponding to the Microsoft Dynamics NAV key should be created. |
|
Determines whether SIFT structures should be created in SQL Server to support the corresponding SumIndexFields for the Microsoft Dynamics NAV key. |