CODE EXAMPLE FOR SQL

stored procedure to change name of column for all dependent tables and views

EXECUTE sp_rename 'Sales.SalesTerritory.TerritoryID', 'TerrID', 'COLUMN';