Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Can we direct change it from sql database? if yes then how?

or

any other solution?

share|improve this question
add comment

2 Answers 2

up vote 14 down vote accepted

No, you can not change internal name of column. You have to delete old column and create new column if you want to change column name

share|improve this answer
    
Thanks for replying –  Hitesh Chandegara Dec 17 '12 at 9:48
2  
you are always welcome –  Vikalp Kapadiya Dec 19 '12 at 11:01
4  
It's worth adding to Rajesh's answer, that in no way, shape or form, should you ever edit any SharePoint configuration or content databases directly in SQL. Database level changes are not supported, which is why Microsoft gives us multiple APIs to manage and manipulate the system. –  webdes03 Dec 19 '12 at 12:49
add comment

Now, I don't know what will happen if you do it, but you can change just about anything using SharePoint Manager (it is called "2007" but works fine in "2010"). The Internal Name I think is the same as StaticName. In SharePoint Manager, if the value of the field is not grayed out, you can change it. Be sure to push the "save" button in the toolbar.

Again, I have never done this, and don't know what will happen if you do!

However, I have used this trick to enable the delete button on a particularly dastardly column that I could not otherwise remove. Worked like a charm, too!

enter image description here

share|improve this answer
3  
I'd be very hesitant to do this unless you have a full backup. –  Kit Menke Dec 19 '12 at 16:10
    
Those types of changes are definitely unsupported. The static name doesn't change because of SharePoint's reliance on that name being consistent for the benefit of other parts of the system. As @KitMenke said, I definitely wouldn't dork around with it in SPM. –  webdes03 Dec 19 '12 at 17:01
1  
Agreed, completely. I don't advocate this. I was only showing the possibility. –  BGM Dec 19 '12 at 19:22
2  
The static name is not the same as the internal name. The static name can be changed, the internal name cannot. The internal name will remain the same, even if you change the static name. Also, SharePoint Manager is just a tool that uses the same APIs that are available to you. There's no magic going on. –  MgSam Jun 13 '13 at 20:20
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.