advanced code snippet search

Posted By

BrentS on 10/24/12


Tagged

sql


Versions (?)

Rename Column Name

 / Published in: SQL
 

URL: http://brenths-development.blogspot.com/2012/10/sql-renaming-column-name.html

http://blog.sqlauthority.com/2008/08/26/sql-server-how-to-rename-a-column-name-or-table-name/

Expand | Embed | Plain Text 
  1. sp_RENAME 'TableName.OriginalColumnName', 'ChangedColumnName', 'COLUMN'
  2. GO

Report this snippet  

You need to login to post a comment.