Rename Column name sql

Method 1:

Syntax:
ALTER TABLE TableName
CHANGE COLUMN OldColumnName NewColumnName Data Type;

Example
ALTER TABLE Test;
CHANGE COLUMN TestingID TestID INT;










Method 2:

Use sp_rename

Syntax :

EXEC sp_RENAME 'TableName.OldColumnName' , 'NewColumnName', 'COLUMN'