SQLTeam.com | Weblogs | Forums

Alter table

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'

1 Like