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

Enabled Property

Determines whether the system will maintain an index for the key. You cannot use a key unless it is enabled.

Key Property

Defines the key.

SumIndexFields Property

Determines the fields for which the system will maintain a SumIndex.

KeyGroups Property

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.

BackupKey Property

Checks if any errors occurred the last time you restored a backup.

MaintainSQLIndex Property

Determines whether a SQL Server index corresponding to the Microsoft Dynamics NAV key should be created.

MaintainSIFTIndex Property

Determines whether SIFT structures should be created in SQL Server to support the corresponding SumIndexFields for the Microsoft Dynamics NAV key.

See Also