SqlIndex Property

Version: Available or changed with runtime version 1.0.

Sets the actual fields that are used in the corresponding index on SQL Server.

Applies to

• Table Key

Syntax

SqlIndex = List of Fields;

Remarks

This property allows you to define the fields that are used in the SQL index.

The fields in the SQL index can:

• Differ in number from the fields defined in the key in Dynamics 365 — there can be fewer fields or more fields.

• Be arranged in a different order.

If you use this property to define an index on a key that is not the primary key, then the index that is created contains exactly the fields that you specify and will not be a unique index. A unique index will only be created if it contains all of the primary key fields.

If you use this property to define an index for the primary key, it must include all the fields defined in the primary key. You can add extra fields and you can rearrange the fields to suit your needs.

Example

The following example uses the SQLIndex property on a primary key that includes two fields. The clustered index in the database will be ordered like this: (MyField2,MyField1).

keys
{
    key(PK; MyField1, MyField2) 
    {
        Clustered = true;
        SqlIndex = MyField2,MyField1;
    }
}

See Also

Properties
Table Keys