Skip to main content

Notifications

Microsoft Dynamics CRM (Archived)

Change Field Schema name (On Premise CRM)

Posted on by 290

Hi All, 

Could you please anyone let me know the possibilities of changing field shemaname?

CRM Details:

On-Premise CRM (Dynamics 365) 

Thanks 

Ashok J

*This post is locked for comments

  • Martin Donnelly Profile Picture
    Martin Donnelly 1,010 on at
    RE: Change Field Schema name (On Premise CRM)

    We DON'T need both Schema and not names.  I just wouldn't be Microsoft if they didn't do silly things that make our lives more difficult.

    Please note that, while there is no need, there is a usage.  On the server/SDK side you will need to use the regular names while on the client side there are odd places where you MUST use the schema name.

  • sai123456 Profile Picture
    sai123456 320 on at
    RE: Change Field Schema name (On Premise CRM)

    Delete the field and create the new field. Make sure you edit the schema name as required before saving.

  • Cherose Profile Picture
    Cherose 40 on at
    RE: Change Field Schema name (On Premise CRM)

    Oh Silly me, I filling in CamelCase in the Name field and on saving, the it would be saved as all lower case but the CamelCase value is saved as SchemaName.

  • Saad Kabarousse Profile Picture
    Saad Kabarousse 732 on at
    RE: Change Field Schema name (On Premise CRM)

    I'm Glad i could've helped :)

  • Cherose Profile Picture
    Cherose 40 on at
    RE: Change Field Schema name (On Premise CRM)

    Yes. Now sure why we need to have different Name and Schema Name in our system.

  • Suggested answer
    Saad Kabarousse Profile Picture
    Saad Kabarousse 732 on at
    RE: Change Field Schema name (On Premise CRM)

    Hi,

    The Only place where you can modify or define  a field's schema name it's at that place.

    But once it's created you can not modify it any more.

  • Cherose Profile Picture
    Cherose 40 on at
    RE: Change Field Schema name (On Premise CRM)

    Thanks for the tips.. I am a newbie. but how can you configure Schema Name without this field shown in the pic Saad posted?

  • Cherose Profile Picture
    Cherose 40 on at
    RE: Change Field Schema name (On Premise CRM)

    Oh Cool.. then the schema name is always identical to the name. but in my system, the format is different although the values are the same. Name uses all lower case and schema name is camel case. How that can be done?

    Also thanks for uploading picture. I find it challenging as you need to upload pics somewhere.

  • Suggested answer
    Martin Donnelly Profile Picture
    Martin Donnelly 1,010 on at
    RE: Change Field Schema name (On Premise CRM)

    Yes, you can. Once you tab away from the Display Name field, the name auto-fills.  The name will become name.ToLower() while the Schema Name will be name as is.  Before saving, you can edit the name field.

    One good, best practice to adopt is for every lookup field you create, add "Id" to the name.  It's not a completely accurate convention in that the lookup is an EntityReference not a Guid but, it is the convention established by Microsoft out of the box.  It makes developing in the sdk a little easier; nice to know what the lookup field is likely to be named.

  • Suggested answer
    Saad Kabarousse Profile Picture
    Saad Kabarousse 732 on at
    RE: Change Field Schema name (On Premise CRM)

    Yes,

    When you are creation a field you can specify the the part after the prefix like "new_" prefix. You specify the name you want. Like its shown in the following img.

    pastedimage1564755393972v1.png

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans