Why column rename script generated by SSMS uses temporary name?
- by abatishchev
When I rename a table column in Designer mode in SQL Server Management Studio 2008 (both R2 and non-R2) and generate a change script it looks like this:
EXECUTE sp_rename N'table.column', N'Tmp_columnNew', 'COLUMN'
GO
EXECUTE sp_rename N'table.Tmp_columnNew', N'columnNew', 'COLUMN'
GO
What for temporary column name is used? Why don't rename at once?