Employ This SQL Stored Procedure to Rename a Column

You can not use the ALTER TABLE statement in SQL Server to rename a column in a table. You can however use the sp_rename stored procedure if you do not want to drop and recreate the table again.

Here is an example of the sp_rename syntax:

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

More From DevX