Alter table to Change Column Name error
sql, sql-server-2008
Solution
Try
EXEC sp_RENAME 'Users.username', 'UserName', 'Column'
...
Problem
Here I tried to ALTER a table to change column name but an error happens. ``` Alter table [dbo].[Users] CHANGE username UserName varchar(50), password PassWord varchar(50), state State int, name Name varchar(50), license License varchar(50), lansno LansNo varchar(50) , curcuit_no CurcuitNo varchar(50) , communism Communism varchar(100) , Olduid OldUid int , Is_hunter Is_Hunter bit , free_text [FreeText] text , country Country varchar(50) , curcuit Curcuit varchar(50) , license_territory LicenseTerritory [varchar](50) , forest Forest varchar(50) , association Association varchar(50), hunt_ar Hunt_Ar varchar(50) , area Area varchar(50) , contract Contract varchar(50) , radio_frequency RadioFrequency varchar(50) ) ``` This error happens: Msg 102, Level 15, State 1, Line 2 Incorrect syntax near 'CHANGE'. So.. I here I tried it to Alter table Change Old column name new column name datatype .. but here I receive the error