How to Rename a Column in SQL Server using sp_rename

Renaming a column in SQL Server is performed by using SP_RENAME stored procedure:

-- syntax
sp_rename 'table_name.old_column_name', 'new_column_name', 'column';

-- rename product_category column in products table
exec sp_rename  'products.product_category', 'category', 'column';
database icon
From SQL Server query to chart to Slack in seconds
Get to answers faster, together, with PopSQL and SQL Server