Aliases - auto-assign when none present
The auto-create alias function is a nice feature, but it does not apply to when I want to open an existing script and apply my formatting/refactoring options. Instead the object name becomes the alias name.
For consistency and readability, I'd like to see an option to assign aliases for objects with none even if not typed and using the intellisense features.
hfxDBA
shared this idea
Thank you for your suggestion.
Ideally, we’d love to respond individually to every request, but currently we can’t due to the volume of unanswered tickets. We’re clearing up our UserVoice backlog to make it easier for us as a small team to prioritize the most valuable features moving forward. Therefore, due to a lack of recent interest in this ticket, we have decided to close it.
If you feel strongly about it, we encourage you to create a new request.
Thanks,
The Prompt Team
-
hfxDBA
commented
to clarify, if I open a script that is not qualifying object names with owner name, I'd like an option to auto-assign an alias instead of using the default full object name.
Simple Example:
select patientId from pt_ge_patients would become...
SELECT [pgp].[patientId] FROM [dbo].[pt_ge_patients] AS [pgp] not...SELECT [pt_ge_patients].[patientId] FROM [dbo].[pt_ge_patients]