In my case RENAME keyword is not working …Error getting
ALTER TABLE Student_Record RENAME COLUMN StudentID TO EmployeeID;