Question : stored procedure to change name of column for all dependent tables and views
Answered by : famous-fowl-ure5kbedim6y
EXECUTE sp_rename 'Sales.SalesTerritory.TerritoryID', 'TerrID', 'COLUMN';
Source : https://solutioncenter.apexsql.com/rename-column-without-breaking-sql-database/ | Last Update : Mon, 31 Aug 20