NEWID

Description

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

Sample Source Pattern

Syntax

SQL Server

NEWID ( )  

Snowflake SQL

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