Generated table alias in uppercase

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
sov
Posts: 16
Joined: Tue 26 Mar 2013 07:05

Generated table alias in uppercase

Post by sov » Tue 26 Mar 2013 07:28

Hi,
Is it possible to get the auto generated table alias in uppercase instead of lowercase?
When typing "select * from sys.objects" and then hitting tab, following is generated: "select * from sys.objects as o". I want the "o" as "O". Is that possible?
Thanks! Stefan.

alexa

Re: Generated table alias in uppercase

Post by alexa » Tue 26 Mar 2013 11:07

Please perform the following actions:

1. Select 'SQL Complete -> Options' from the main menu. The 'Options' window opens.
2. Navigate to the 'Formatting -> Profiles' branch.
3. Select a profile.
4. Click 'Edit Profile...'. The 'Edit Profile' window opens.
5. Expand the 'Text Case -> Identifier Case' node.
6. Select the 'Upper' option.

sov
Posts: 16
Joined: Tue 26 Mar 2013 07:05

Re: Generated table alias in uppercase

Post by sov » Wed 03 Apr 2013 08:28

Thank you for the reply, but that is not what I want.
The suggestion results in uppercased schema and tablenames, e.g. "select * from SYS.OBJECTS as O".
Is it possible to only capitalize the alias?

alexa

Re: Generated table alias in uppercase

Post by alexa » Wed 03 Apr 2013 16:54

Unfortunately, this is not possible. However, we already have such functionality in our roadmap for future product releases.

sov
Posts: 16
Joined: Tue 26 Mar 2013 07:05

Re: Generated table alias in uppercase

Post by sov » Wed 03 Apr 2013 19:32

Could you please tell me, when this feature will be released?

alexa

Re: Generated table alias in uppercase

Post by alexa » Fri 05 Apr 2013 09:29

Unfortunately, this will not be implemented in the nearest future.

sov
Posts: 16
Joined: Tue 26 Mar 2013 07:05

Re: Generated table alias in uppercase

Post by sov » Wed 15 Jan 2014 08:19

Thank you for releasing this functionality in version 4.5 !

Post Reply