Unique Identifier in SQL Server - Equivalent in Teradata ?

Database
SAP
Enthusiast

Unique Identifier in SQL Server - Equivalent in Teradata ?

Hi All ,

Can anyone help me with Equivalent in Teradata for Unique Identifier in SQL Server ? Though i can accomodate the values with VARCHAR datatype but when i need unique values to be generated . What will i do in that case ?

Thanks in advance !!!

4 REPLIES
Enthusiast

Re: Unique Identifier in SQL Server - Equivalent in Teradata ?

will this help you select ROW_NUMBER() OVER (ORDER BY fieldnames) , a.* from your_table a;

I am not able to follow when you say "I can accomodate ........"

Teradata  do have identity column, but I prefer using query :)

SAP
Enthusiast

Re: Unique Identifier in SQL Server - Equivalent in Teradata ?

Thanks Raja !!! 

I shall explain in detail :- 

Actually we are migrating from SQL Server to teradata . In SQL Server Unique identifier is a datatype used in DDLs . This creates a global unique number [ something like this : DF GH 44 YI ...] using MAC address . There cannot be any unique number for a record than this in whole universe , [[they say]] :) :O . Now data in SQL serevr is in this format .

When i migrate , i can accomodate those records in VARCHAR and use use ROW_NUMBER but do we have any concept like Unique Identifier in Teradata ??? I have to find a equivalent in teradata which should very much near to the functionality .

Enthusiast

Re: Unique Identifier in SQL Server - Equivalent in Teradata ?

I am not  a SQL server person :). Teradata's unique identity column is different. However, if you know the functionality you can think of a UDF. That is my thought.

SAP
Enthusiast

Re: Unique Identifier in SQL Server - Equivalent in Teradata ?

Thanks Raja !!!