Feature Request: Add support for DESC/ASC specification in Indexes tab of Table Editor

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
tfrancois
Posts: 44
Joined: Mon 11 Jun 2018 23:58

Feature Request: Add support for DESC/ASC specification in Indexes tab of Table Editor

Post by tfrancois » Mon 07 Mar 2022 11:45

Support for specifying ASCending or DESCending order of indexed columns was added as of MySQL v8. Currently, in the Indexes tab of the table editor, there is no way to take advantage of this when creating or update index definitions.

Please add the ability to modify default sort order when adding or modifying indexes to MySQL 8+ tables. See MySQL 8 documentation that discusses this important feature:
https://dev.mysql.com/doc/refman/8.0/en ... dexes.html

P.S.: Interestingly, support for invisible indexes was added in the Indexes tab in the table editor (top right) so I was surprised to see that the sort order was omitted.

Raudar
Devart Team
Posts: 19
Joined: Fri 02 Apr 2021 11:04

Re: Feature Request: Add support for DESC/ASC specification in Indexes tab of Table Editor

Post by Raudar » Tue 15 Mar 2022 14:09

Hi there,

It's currently in our roadmap and will be added in the future.

Regards,
Devart Support

Post Reply