/SQL/Change column name sql server management studio

Change column name sql server management studio

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

Rename column name sql server

EXEC sp_RENAME 'table_name.old_name', 'new_name', 'COLUMN'

Source: stackoverflow.com

Change column name sql server management studio

EXEC sp_RENAME 'table_name.old_name',  'new name',  'COLUMN'

Similar codes

15 votes368 views3 answers
Mysql update add to existing value
SQL
0 vote310 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
1 vote301 views1 answer
Find logged in users mysql
SQL
9 votes335 views2 answers
Sql server check table exists
SQL
0 vote338 views1 answer
Postgresql find missing id
SQL
11 votes308 views1 answer
How to get ddl for materialized view
SQL
5 votes335 views4 answers
Sqlite3.OperationalError: near "WHERE": syntax error
SQL
0 vote346 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
0 vote323 views1 answer
Postgres execute multiple sql file from command line
SQL
5 votes381 views1 answer
Mysql where one year ago
SQL