Key Properties

The keys associated with a table have properties that describe their behavior, just as tables and fields do. When you create a key, Dynamics 365 Business Central 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.

Note

This article may not include all properties for this object. To see a complete list of properties, use the table of contents from Properties Overview. In Visual Studio Code, use Ctrl+Space to see the properties available for the object and its controls.

Property Name	Use
Enabled	Determines whether the system will maintain any indexes for the key. You cannot use a key unless it is enabled.
Key	Defines the key name and fields.
SumIndexFields	Determines the fields for which the system will maintain a SumIndex.
MaintainSQLIndex	Determines whether a SQL Server index corresponding to the fields in the key should be created.
MaintainSIFTIndex	Determines whether SIFT indexes (indexed views) structures should be created in SQL Server to support the corresponding SumIndexFields for the Dynamics 365 Business Central key.
Clustered	Sets a value that indicates whether the key defines the clustered index for the table.
SQLIndex	Sets the actual fields and field order that are used in the corresponding index on SQL Server.
Unique	Sets whether the value of a key must be unique.

See Also

Table Keys