Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

Dynamic Crm database tabe and Crm interface

Posted on by

Hi,

For example if I edit the Account name field length  from 100 to 50 in CRM interface, will that be automatically changed in the Dynamic CRM Sql table as well or just on the UI side?

Thanks

*This post is locked for comments

  • Verified answer
    Mahadeo Matre Profile Picture
    Mahadeo Matre 17,021 on at
    RE: Dynamic Crm database tabe and Crm interface

    SQL changes are not supported for CRM.

    When you are decreasing length of any attribute, attribute length in SQL will not be changed, because CRM is not truncating attribute value.

    If you changed account name from 100 to 50, but you have some account names which are created before your change and has account name 100 characters long, this data is still shown to user, data will not be truncated.

    When you increase length say from 100 to 200, then attribute length will be increase in SQL to fit new values.

  • RE: Dynamic Crm database tabe and Crm interface

    Thanks for the quick reaponse Mahdeo.

    Can you please advise  what are the steps in order to do that in the CRM  sql side  as well.Also is that  supported way to change in sql side.

    Thanks for all the help!

  • Suggested answer
    Mahadeo Matre Profile Picture
    Mahadeo Matre 17,021 on at
    RE: Dynamic Crm database tabe and Crm interface

    UI side only.

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!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans