Published on: 18 Feb, 2021

How to rename a column in TSQL?

Tumblr Digg Google Plus

If you need to rename a column of a table in TSQL. You have to use the built-in function 'sp_RENAME'. Let says we have the following table product.

Here is the full TSQL query to rename a column in SQL Server.


sp_RENAME 'Products.Description' , 'ProductDescription', 'COLUMN'

Here is the final result after we run above the TSQL code.

Comments

There are no comments available.

Write Comment
0 characters entered. Maximum characters allowed are 1000 characters.