Updating length of "Name" attribute in SQL Master Data Service RRS feed

  • Question

  • Hi Guys

    I have came across a requirement where there is a need to update the length of automatically populated "Name" field in MDS tables from standard 255 characters to 4000 characters.

    I tried doing this via MDS GUI, but any changes to "Code" & "Name" attribute is restricted there.

    I searched on forum and web & couldn't find any post supporting this but not much says against it as well.

    I tried it doing directly on the core tables of MDS "mdm.tbl_1_XXX_EN" using the alter column and it was successful. But I am still not convinced should we do it or not. If it would have any poor impacts on performance or break MDS model in any way.

    Can you please advise for the same?

    Many thanks,


    Thursday, July 23, 2020 4:05 AM