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

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

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