Thursday, June 25, 2009

Rename an Existing Column of a Table in MS SQL

In SQL server , Renaming a existing column without any data loss is possible .
A Inbuild System Stored Proc is available for the same

Syntax
EXEC sp_rename `tableName.[existingColumnName]`, `newColumnName`, `COLUMN`

Eg:
EXEC sp_rename `tblShortName.[longName]`, `shortName`, `COLUMN`

The above SP on execution will change the column longName in the tblShortName table to shortName

Note :

Take care you make the changes in all the stored proc and function where you are refering the old Column to the new Column

3 comments:

  1. Today’s most accurate tip for stock
    BUY HINDALCO 120 PUT ABOVE 3.10 TG- 3.60/4.40/5.50 SL- 1.90
    Free option tips

    ReplyDelete
  2. FUTURE DAFS POINT PLAN BUY NSE TITAN BTWN 852- 853 TARGET 862-872 SL 843
    OUR FIRST TGT 862 ACHIEVED IN TITAN BUY CALL, ONCE BOOK PARTIAL PROFIT AND TRAIL SL AT COST
    Stock Market Tips

    ReplyDelete
  3. Best recommendations on stock market you can get here.
    Trade India Research Reviews

    ReplyDelete

Express you views