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.