SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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


any other solution?

share|improve this question
up vote 19 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
you are always welcome – Vikalp Kapadiya Dec 19 '12 at 11:01
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

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
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
Agreed, completely. I don't advocate this. I was only showing the possibility. – bgmCoder Dec 19 '12 at 19:22
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

The easiest way to do this is to name column for e.g. _dlc_static_Name_cat save filed later edit field and change name e.g. Cat in caml editor you will see that column name internal is _dlc_static_Name_cat and display Cat

share|improve this answer

Your Answer


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.