Optional column alias when expanding wildcards
When SQL Prompt gives you the option to expand wildcards by typing a TAB, can you make it possible to add a modifier key (say Alt-TAB or Ctrl-TAB) that will generate aliased column names based on the table name?
For example, on an insert or update statement, we can use the OUTPUT clause to capture the changes made to a table. So, currently, typing Deleted.* and pressing TAB will generate columns such as
Deleted.Id,
Deleted.ModifiedDate,
Deleted.Description
and so on.
It would be more useful to have
Deleted.Id as DeletedId,
Deleted.ModifiedDate as DeletedModifiedDate,
Deleted.Description as DeletedDescription
8
votes
Chris Young
shared this idea