Often in my c# code, I can change the name of a variable, and all references to it will change as well.
Is there a similar feature that allows me to do this with objects in SQL servers? Some of my tables, columns, and stored procedures are in need of renaming, but of course I want to keep it all functioning.