I am very new to SQL and I am trying to change the name of a column using ALTER TABLE / RENAME functions but an error message keeps popping up.
Any other way I can solve this?
Right click on the table and navigate to the design and them modify the column name.
I might be clicking somewhere wrong, because I cannot even see this option. Thank you Ahmed.
EXEC sys.sp_rename 'dbo.table_name.current_column_name', 'new_column_name', 'COLUMN'