SQL Server Data Types - UNIQUEIDENTIFIER

Versions: SQL Server 2008, 2005, 2000, 7.0 and 6.5

SQL Server - UNIQUEIDENTIFIER
Syntax	UNIQUEIDENTIFIER
Data	Globally unique identifier (GUID)
Storage Size	16 bytes
Standards	SQL Server Extension

An example of UNIQUEIDENTIFIER:

6F9619FF-8B86-D011-B42D-00C04FC96431

SQL Server UNIQUEIDENTIFIER - Equivalents in Other Databases

Database	Data Type and Conversion
PostgreSQL	UUID
Sybase ASE	CHAR(32) for UUID values without dashes, or CHAR(36) for UUID values with dashes; NEWID() function can be used to generate UUID values

All Data Types

Oracle

SQL Server

IBM DB2

MySQL

PostgreSQL

Sybase ASE

Sybase ASA

Informix DS

Teradata

HP Neoview

Interbase/Firebird