Automatically alias tables and columns in existing scripts
Please could you add a feature that parses a query that has already been written, adds aliases for tables that don't already have them and update columns to use those aliases.
This is because I often get pieces of code which are partially aliased and I have to go through updating the missing ones. Thanks.
Gert Hauan commented
What is the status of this request? Has it been implemented? If not, will it? If yes, how can we apply it?
This would be very helpful! I always have aliases for all columns
Nihar Bhalerao commented
I would like to take this a step further and also suggest that it would be better if SQL Prompt could schema qualify execution calls to child procs if it detects a missing schema name. This is particularly useful fro SQL 2017 where the optimizer is generating a CacheMiss event when schema name is not used in proc name.