Automatic Alias from Table Name
Rather than individually defining aliases per table, add an option to use capitalised letters of tables/views to define an alias.
eg.
Customer = C
mem_Membership = M
cus_StateCustomer = SC
aReallyLongTableName = RLTN
view_CustomerMembership = CM
Chris
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
-
Glenn
commented
you can also use the "Prefixes to ignore".
Add "mem", "cus" and "view" to this list, and you will get exactly what you are looking for. -
Aaron Bauman
commented
Paul, I tried the Alias option and here's some additional functionality that could improve it.
If I use a table and that table has an alias, use the alias. (current functionality)
If the table does not have an alias, don't automatically assign an alias. (new option)
Reason: I didn't care for the auto generated aliases. -
AdminPaul Stephenson
(Admin, Redgate)
commented
SQL Prompt already does this to some extent. Try Options > Aliases > Assign aliases and don't put in any custom aliases. If the table or view name has underscores or hyphens, or is composed of two words with initial capital letters (such as MyTable) SQL Prompt takes this into account when generating the alias.
Does this work for you?