Fields in Alpha Order
Add an option to expand SELECT * to allow the expansion of the fields to be ordered in the order they currently are or to have the fields listed in Alphabetical order. I work with some tables that have many, many fields and they aren't in a very logical sequence, so I end up searching for the field I want. If I could expand the SELECT * and have the fields be in alphabetical order that would help a lot.
Of course I can use Find to find the field I want, or create a snippet that lists these table fields in alphabetical order, but it would be nice to have this option.
SQL To List Table Columns in Alphabetical Order:
SELECT COLUMNNAME
FROM INFORMATIONSCHEMA.COLUMNS
WHERE TABLENAME = 'MYTABLE'
ORDER BY COLUMN_NAME;
-
AdminDevart (_, Devart) commented
Hi,
Thanks for your post!
Please be infromed that Product team has already added this feature to our plans, but there is no ETA for it.
We would suggest checking time to time our Revision History, where new fixes and feature are specified to each new releas.
Anyway, once there is an update regarding implementation and release, you will be informed.
Best,
Devart Support Team