NEWID

Description

Creates a unique value of type uniqueidentifier. (NEWID in Transact-SQL).

Sample Source Pattern

Syntax

SQL Server

NEWID ( )  

Snowflake SQL

Snowflake SQL Documentation

UUID_STRING()

Examples

Outputs may differ because it generates a unique ID in runtime

SQL Server

Code:

SELECT NEWID ( ) AS ID

Result:

                                  ID|
------------------------------------+
21AA426B-0A2B-400C-8558-B718C59A9D51|

Snowflake SQL

Code:

SELECT UUID_STRING() AS ID;

Result:

                                  ID|
------------------------------------+
33330dcf-a258-4d77-9e74-8a1afd8ddcf1|