Firebird Documentation IndexFirebird 2.5 Language Ref. UpdateInternal functions → GEN_UUID()
Firebird Home Firebird Home Prev: GEN_ID()Firebird Documentation IndexUp: Internal functionsNext: HASH()

GEN_UUID()

Tip

Find a more recent version at Firebird 5.0 Language Reference: GEN_UUID()

Available in: DSQL, PSQL

Added in: 2.1

Description: Returns a universally unique ID as a 16-byte character string.

Result type: CHAR(16) CHARACTER SET OCTETS

Syntax: 

GEN_UUID ()

Example: 

select gen_uuid() from rdb$database
-- returns e.g. 017347BFE212B2479C00FA4323B36320 (16-byte string)

See also: UUID_TO_CHAR(), CHAR_TO_UUID()

Prev: GEN_ID()Firebird Documentation IndexUp: Internal functionsNext: HASH()
Firebird Documentation IndexFirebird 2.5 Language Ref. UpdateInternal functions → GEN_UUID()