Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

change column names mssql

--The following example renames the column TerritoryID in the table Sales.SalesTerritory to TerrID in the AdventureWorks database.

EXEC sp_rename 'Sales.SalesTerritory.TerritoryID', 'TerrID', 'COLUMN';
 
PREVIOUS NEXT
Tagged: #change #column #names #mssql
ADD COMMENT
Topic
Name
9+4 =