/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

0 vote224 views1 answer
How to check even or odd in sql
SQL
0 vote243 views1 answer
How to get nth number in sql
SQL
3 votes239 views2 answers
Mysql select database
SQL
0 vote231 views2 answers
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
SQL
0 vote218 views2 answers
Nosqlbooster query other collection
SQL
0 vote217 views1 answer
Google sheets filter rows above current cell
SQL
0 vote278 views1 answer
How to check foreign key constraint in sql
SQL
0 vote225 views1 answer
Oracle list subpartitions
SQL
0 vote270 views1 answer
Snowflake drop column
SQL
0 vote223 views1 answer
Mysql server not running
SQL