Tuesday 27 January 2015

Query to rename column name in Sql Server 2008

Syntax:

  EXEC sp_RENAME 'TableName.OldColumnName' , 'NewColumnName', 'COLUMN'

Query Example:

  EXEC sp_RENAME 'ExceptionLog.exceptionLog', 'LogMessage', 'COLUMN'


Enjoyyy....

0 comments:

Post a Comment


                                                            
 
Design by Abhinav Ranjan Sinha