<< GEN_ID() | FB 2.5 Language Reference | HASH() >>

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()

back to top of page
<< GEN_ID() | FB 2.5 Language Reference | HASH() >>