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

Kristin.R.531 Posts: 8 🌱

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: 109
    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!