What the Heck Microsoft?
03 July 2013
Ok, I know Microsoft isn't big on following laid out standards, but it doesn't stop it from causing headaches. Today I found out that a simple column rename in SQL server is not possible with standard, well documented SQL.
alter table tablename change oldname newname varchar (10);Instead I have to use some sort of SQL Server procedure sp_rename
sp_rename 'TableName.ColumnName', 'NewColumnName', 'COLUMN'