14

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

or

any other solution?

25

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

  • 2
    you are always welcome – Vikalp Kapadiya Dec 19 '12 at 11:01
  • 6
    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
  • Yeah but changing a list name and having the name not update in the backend? Completely ludicrous and poor programming. – Xogle Jul 26 '17 at 18:24
1

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

  • 4
    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. – bgmCoder Dec 19 '12 at 19:22
  • 4
    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
  • EntityPropertyName is Rest API name that i want to change it. Is there any program or sources on github that get oldfieldname and newfieldname and list name then copy all data to new generated filed ? – saber tabatabaee yazdi Mar 7 '17 at 12:45
1

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

0

when you have reports that connected to this datas

or

when we have same internal name like year and want to use site column for example : Year and SharePoint Entity internal name set Year0 with zero added unwanted character

you have harder way:

  1. Copy field data to new tempField by Access or etc.
  2. delete oldfield
  3. create new one by your desired name
  4. copy from tempField to new by Microsoft Access

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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