SQL Alias in upper case in Version 4

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
rolfz
Posts: 7
Joined: Fri 21 Aug 2015 13:45

SQL Alias in upper case in Version 4

Post by rolfz » Tue 02 Oct 2018 11:18

Hi,
Starting with Version 4 Aliases in SQL are in capital letters. We would like to have it in lower case as it was in Version 3 when pressing [Ctrl K D]. We found an something in Tools - Option [Text Editor - Code Completion - Alias -> Generate aliases in UPPER case]. This is disabled, but still, the formating is in Upper case. Does this not work as expected or is this something different?

alexa
Devart Team
Posts: 2558
Joined: Fri 24 Jun 2011 14:17

Re: SQL Alias in upper case in Version 4

Post by alexa » Tue 02 Oct 2018 12:57

Please perform the following:
1. Select 'Tools -> Options...' from the main menu. The 'Options' window opens.
2. Navigate to the 'Text Editor -> Formatting -> Profiles' branch.
3. Select the active profile and click the 'Edit Profile...' button. The 'Edit Profile' window opens.
4. Expand the 'Text Case -> Alias Case' node.
5. Select the 'Lower' option.

rolfz
Posts: 7
Joined: Fri 21 Aug 2015 13:45

Re: SQL Alias in upper case in Version 4

Post by rolfz » Wed 03 Oct 2018 09:32

Great, that works as expected. Thx.

alexa
Devart Team
Posts: 2558
Joined: Fri 24 Jun 2011 14:17

Re: SQL Alias in upper case in Version 4

Post by alexa » Tue 09 Oct 2018 08:56

Please let us know if any questions arise.

Post Reply