Table Alias Recognized in SELECT * FROM
In SQL Prompt Options, I can Alias tables (PATIENT = Pat). If we take the time to Alias my tables in the options, could we have the ability to have the Alias show up in the Intellisense? i.e. SELECT * FROM... the All Suggestions shows my Aliases first, then the tables. In addition, if I type SELECT * FROM Pa... have the suggestions show me all the aliases that start with PA, then all the tables, etc.
Derek Kennard
shared this idea
1 comment
-
Derek Kennard
commented
Commenting on my own post because I forgot to add something.
If this option is made available to us, I would like to see the fully qualififed name returned if I select an alias as a suggestion. For instance, SELECT * FROM Pat (<- the alias) returns SELECT * FROM PATIENT AS [Pat]. It uses the same formatting logic the my SQL Prompt options are set to.
