Provide a global rename option of and alias
Have the ability to right-click or hover over an alias and be able to choose "Rename". By renaming the alias in one place it would automatically rename all other references to the alias in the query.
For example: I create a table and it get aliased as r1. I then rename it to rnk, which would change the loin reference to rnk right away.
The feature is implemented in SQL Complete v4.7.
-
Sheldon commented
Well done on the implementation, it is scope specific and doesn't rename the reused alias in a subquery or other area.
Thanks!
-
Jade commented
It's a good idea!
But I suggest to release the idea such way:
1. set cursor to object you want to rename
2. press F2 button (it's more fast and easy in comparison with context menu).And what about rename variables the same way?