# Properties for table keys
Table keys have properties that control their behavior and the corresponding indexes in SQL Server.
> 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<https://learn.microsoft.com/dynamics365/business-central/dev-itpro/developer/includes/..\properties\devenv-properties>. In Visual Studio Code, use Ctrl+Space to see the properties available for the object and its controls.
Property|Description
devenv-clustered-property|Specifies whether the key defines the clustered index for the table.
devenv-description-property|Specifies a description for the key.
devenv-enabled-property|Specifies whether the system maintains indexes for the key.
devenv-includedfields-property|Specifies non-key fields to include in the SQL index.
devenv-maintainsiftindex-property|Specifies whether SQL Server maintains indexed views for the key's SumIndexFields.
devenv-maintainsqlindex-property|Specifies whether SQL Server creates an index for the key.
devenv-obsoletereason-property|Explains why the key is obsolete.
devenv-obsoletestate-property|Specifies whether the key is obsolete.
devenv-obsoletetag-property|Specifies the version in which the key became obsolete.
devenv-sqlindex-property|Specifies the fields and field order of the corresponding SQL Server index.
devenv-sumindexfields-property|Specifies the fields for which the system maintains a SumIndex.
devenv-unique-property|Specifies whether key values must be unique.
## Related information
../devenv-table-keys
Table and table extension properties<devenv-table-property-overview>
devenv-properties

Copyright (c) Microsoft Corporation. CC BY 4.0, https://creativecommons.org/licenses/by/4.0/; code samples MIT. From https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/properties/devenv-key-properties, MicrosoftDocs/dynamics365smb-devitpro-pb at 828b6ee (2026-11-19). Changed: includes filled in, links to this site, and for agents shortened without dropping a fact. https://jonas-paprotka.de/docs/dev-itpro/developer/properties/devenv-key-properties/
