What is the max length of the data column of type "unique identifier"?


In some of the data set ERDs, there are columns identified as "unique identifier" data type (i.e. Activity Feed Post Log > LogId). We are warehousing data from these sets. I can code this column as a varchar but how long do these strings get?

Best Answer

  • Chris.S.534
    Chris.S.534 Posts: 217
    Answer ✓

    Hi Kristin, These identifiers are GUIDs that follow the 'standard' GUID format XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX and are 36 characters in length. Hope that helps!