I am trying to change the name of one of the columns in my table using the rename function in SQL, but it always shows "Incorrect Syntax near 'RENAME'".
I've tried rewriting the specific part again and also used the Change function as well, which resulted in the same error.
SQL RENAME ERROR(https://i.stack.imgur.com/NLiFI.png)
ALTER TABLE Employeesalary
RENAME COLUMN Gross_Pay TO Salary;