I am using SQL Server 2008 and Navicat. I need to rename a column in a table using SQL.
ALTER TABLE table_name RENAME COLUMN previous_name to new_name;
This statement doesn't work.
If you need to know more about SQL, it is recommended to go for the SQL Online Course today.