Requesting Help: Alias Generator

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
AbstractSQL
Posts: 2
Joined: Wed 07 Nov 2018 00:51

Requesting Help: Alias Generator

Post by AbstractSQL » Wed 07 Nov 2018 00:55

Hey all,

I am looking for the Action code for, or how to do, the following:

I would SQL Complete's Alias feature to turn my code

SELECT * FROM dbo.vtblName_View

Into

SELECT * FROM dbo.vtblName_View vtblName_View

Is this possible?

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

Re: Requesting Help: Alias Generator

Post by alexa » Wed 07 Nov 2018 09:14

This can be achieved as follows:
1. Select 'SQL Complete -> Options...' from the main menu. The 'Options' window opens.
2. Navigate to the 'Alias' branch.
3. Specify vtblName_View in both columns (Condition and Action).
4. Click 'OK'.

AbstractSQL
Posts: 2
Joined: Wed 07 Nov 2018 00:51

Re: Requesting Help: Alias Generator

Post by AbstractSQL » Wed 07 Nov 2018 14:15

Thank you very much for your response. I should have been more specific.

I understand that the alias generator will abbreviate using capital letters, but I have hundreds of tables and thousands of views.

I basically want the alias generator to generate an alias using the full object name (minus schema and database).

If my view was vtblRefDataSet_Select then the alias should be vtblRefDataSet_Select
If it was vtblRefDataSet_Update then vtblRefDataSet_Update. It may seem counterintuitive.

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

Re: Requesting Help: Alias Generator

Post by alexa » Fri 09 Nov 2018 10:10

There is no such a possibility. Though, you can vote for the following suggestion on the UserVoice forum https://devart.uservoice.com/forums/878 ... of-table-n

We collect and analyze the information from this forum in order to make a proper roadmap for future product releases.

Post Reply