RSS

Monthly Archives: May 2011

MS SQL rename column

exec sp_rename ‘tableName.ColumnName’, ‘newColumnName’, ‘COLUMN’

EXEC sp_rename 'LeadTracking.cSource', 'cSourceLookupId', 'COLUMN'

Original source

http://dotnetcoderoom.wordpress.com/2008/09/02/rename-a-table-column-in-ms-sql/

 
Leave a comment

Posted by on May 19, 2011 in SQL

 

Tags: