Devart Forums

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?

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'.

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.

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.