Search code examples
mysql-workbenchuppercase

How can I have MySQL Workbench autocomplete with uppercase?

By default, autocompletion is lowercase. Is there any way to have it uppercase?

enter image description here

Solution

  • I submitted bug report:

    Description: The autocompletion uses lowercase instead of uppercase, which is inconsistent with the SQL generated e.g. when altering a table, as well as with the ANSI standard http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt Demo: http://youtu.be/oRcjJcaej-M

    How to repeat: In the SQL Editor, type "AL" then hit Ctrl+Space to trigger the auto completion. Demo: http://youtu.be/oRcjJcaej-M

    Suggested fix: Use uppercase.

    The issue is now solved:

    Fixed as of the upcoming MySQL Workbench 6.0.4 release, and here's the changelog entry:

    A new preference was added to toggle casing for the generated keywords in the auto completion list. "Edit", "Preferences", "SQL Editor TAB", "Use uppercase keyboards on completion".

    enter image description here