Tell me more ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.
up vote 1 down vote favorite

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

or

any other solution?

share|improve this question

2 Answers

up vote 10 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
2  
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
up vote 1 down vote

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
1  
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

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.