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. In Visual Studio Code, use Ctrl+Space to see the properties available for the object and its controls.

PropertyDescription
Clustered propertySpecifies whether the key defines the clustered index for the table.
Description propertySpecifies a description for the key.
Enabled propertySpecifies whether the system maintains indexes for the key.
IncludedFields propertySpecifies non-key fields to include in the SQL index.
MaintainSIFTIndex propertySpecifies whether SQL Server maintains indexed views for the key's SumIndexFields.
MaintainSQLIndex propertySpecifies whether SQL Server creates an index for the key.
ObsoleteReason propertyExplains why the key is obsolete.
ObsoleteState propertySpecifies whether the key is obsolete.
ObsoleteTag propertySpecifies the version in which the key became obsolete.
SQLIndex propertySpecifies the fields and field order of the corresponding SQL Server index.
SumIndexFields propertySpecifies the fields for which the system maintains a SumIndex.
Unique propertySpecifies whether key values must be unique.

Table keys
Table and table extension properties
Properties