All Forums Database
sridharg.rao 1 post Joined 11/15
21 Mar 2016
GUID data type equivalent in Teradata

GUID data type stores “16-byte binary values” that operate as globally unique identifiers.
 
It can be logically grouped into the following subgroups:
4byte-2byte-2byte-2byte-6byte
The standard textual representation is {12345678-1234-1234-1234-1234567890AB}.
 
Is there a Teradata equivalent for this? If no, which data type could be the closest?

tomnolan 594 posts Joined 01/08
21 Mar 2016

You can store a GUID in character format in a VARCHAR column, or store a GUID as a binary value in a VARBYTE column.

You must sign in to leave a comment.