Define sort order of index created in AOT

(0) Share

Report

Posted on by Community Member

Hi,

We are trying to define a descending sort order in one of our AX table indexes but it defaults to ascending back in SSMS. Is there a way of changing the default sort order from ASC to DESC for indexes created in AOT? We understand we can change this in SSMS but trying to avoid it as much as we can. Appreciate your expert response.

Many thanks,

Reynaldo

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

André Arnaud de Cal... 301,053 Super User 2025 Season 2 on at

Like (0)

Report

Hi Reynaldo,

This is not possible, so you have to manage it in SSMS or also on e.g. AX forms or within X++ logic you can set the order to descending.

Was this reply helpful? Yes No