advanced code snippet search

Posted By

naspinski on 01/11/09


Tagged

sql mssql column


Versions (?)

rename a column is MS SQL

 / Published in: SQL
 

URL: http://naspinski.net/post/Change-column-name-in-a-MSSQL-table.aspx

Just replace TABLENAME.OLDCOLUMNNAME and NEWCOLUMNNAME with your new values.

Expand | Embed | Plain Text 
  1. EXEC sp_rename 'TABLENAME.OLD_COLUMNNAME', 'NEW_COLUMNAME', 'COLUMN';

Report this snippet  

You need to login to post a comment.