Thursday, August 27, 2009

T-SQL to Rename a Column Name or Table Name

renaming any column :
sp_RENAME 'TableName.[OldColumnName]' , '[NewColumnName]', 'COLUMN'

renaming any object (table, stored procedure etc) :
sp_RENAME '[OldTableName]' , '[NewTableName]'