Skip to content

How can we improve SQL Prompt?

SQL Prompt

CATEGORIES
All ideas
My feedback
Code Analysis 48 ideas
Encapsulate as new stored procedure 1 idea
Expand wildcards 7 ideas
Find invalid objects 7 ideas
Find unused variables 3 ideas
Format SQL 187 ideas
Intellisense 77 ideas
Platform Support 16 ideas
Qualify object names 6 ideas
Script object as alter 14 ideas
Smart rename 10 ideas
Summarize script 5 ideas
Tab coloring 5 ideas
Tab history 42 ideas
User interface 88 ideas

Searching…

No results.
Clear search results

- Flyway 15 ideas
- MySQL tools 24 ideas
- Oracle 129 ideas
- Redgate 0 ideas
- SQL Change Automation 50 ideas
- SQL Compare 249 ideas
- SQL Data Compare 110 ideas
- SQL Prompt 663 ideas
- SQL Search 133 ideas
- SQL Source Control 588 ideas
- SQL Toolbelt Essentials 16 ideas
Redgate

Automatic Alias from Table Name

(5 previous votes)

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

https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/1931235-automatic-alias-from-table-name

4 votes

Chris shared this idea · Oct 3, 2018 · Report… · Admin →

An error occurred while saving the comment

Anonymous commented · November 7, 2019 12:50 AM · Report

Our standards prevent us using meaningless acronyms (e.g. does "C" mean "Customer" or "Case"?), so I cannot support this idea. However, if you were to make this more flexible, e.g. to support this request... https://redgate.uservoice.com/forums/94413-sql-prompt/suggestions/1409785-table-name-as-alias then it would definitely have backing from me (and probably others).

Submitting...