Alter column name in mssql

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';

Source: grepper.com

Modify column name in tsql

sp_rename 'table_name.old_column', 'new_name', 'COLUMN';

-2

Source: techonthenet.com

Similar codes

0 vote149 views1 answer
Mysqldump don't drop table
SQL
0 vote141 views1 answer
Get server date mysql
SQL
2 votes164 views3 answers
Postgres json to string
SQL
4 votes173 views1 answer
How to check last gather stats on table in oracle
SQL
8 votes126 views2 answers
Phpmyadmin password
SQL
0 vote138 views1 answer
Get clob size oracle
SQL
3 votes154 views1 answer
How to uninstall microsoft sql server
SQL
0 vote145 views1 answer
Sql put two columns into one
SQL
1 vote153 views1 answer
Oracle stop
SQL
0 vote135 views1 answer
Create synonym for dblink in oracle
SQL