Please add an option to propogate a name change down through the dependency hiearchy. If I change a column name, I would prefer the view/function not keep the old name as an alias, even if this means my rename script will have to touch many more items.
I would hope this could work similar to SQL Compare where there is an additional check box to script dependent items.
Smart rename is great, but I don't want to have to run it multiple times to rename a single column across all of my objects.
In my specific example, I want to rename a column in a table which is used in a view, which is used in a function, which is called in various other functions and views. When I rename the column, only the first view is updated and the new column uses the old name as an alias for the view. What I want is Smart Rename to script all of the downstream views and functions with the new column name.