SQL Tutorial Home

How to Rename a Column in MS-SQL

To rename a column in a table, MS-SQL Server has a stored procedure sp_rename. Use the SP as shown below:

EXEC sp_rename 'employee.last_bonus_date', 'last_bonus', 'COLUMN';