After renaming a column in SQL Server 2008, the name doesn't change in table design view
Posted on 2013-12-30
Once I rename a column in a table by using sp_RENAME (as below), I can see that the name has changed when I view the table in 'edit all rows' mode, but it still has the old column name in design view. I refresh the table - and even the database - but the column still has the old name in design view. Only when I close and reopen SSMS has it updated.
sp_RENAME 'TableName.OldColumnName' , 'NewColumnName', 'COLUMN'