Monday, 6 January 2014

How to rename database table column with new name?

You need to use the sp_rename command, or use Management Studio to do it visually. Now, to change the Column Name from "Old_Name" to "New_NameChange" we can use command: 
sp_RENAME 'Table_Name.[Old_Name]', '[New_NameChange]' , 'COLUMN'
Posted by at

5 comments:

  1. Unknown21 March 2015 at 12:39

    Thanks for your informative article. Your pose helped me a lot to under the future in .Net mobile application development. .Net Training

    ReplyDelete
  2. Unknown13 June 2015 at 16:01

    I get a lot of great information from your blog. Thank you for your sharing this informative blog. I have bookmarked this page for my future reference.

    Regards...
    Ethical Hacking Course in Chennai

    ReplyDelete
  3. Unknown2 July 2015 at 14:29

    Nice Post. Testing is a process of executing a program in order to find any errors, missing requirement or gaps to the original requirements.
    Regards...
    Software Testing Course in Chennai

    ReplyDelete
  4. Tech Fug6 May 2016 at 19:11

    Facebook, Google, Airtel, Idea, Vodafone, BSNL & More tips and tricks

    Tips & Tricks

    ReplyDelete
  5. Devi8 August 2020 at 15:39

    Thank you for your post. This is excellent information. It is amazing and wonderful. oracle training in chennai

    ReplyDelete

Subscribe to: Post Comments (Atom)