GUID()

Purpose

Function to generate and return a 36 character unique GUID

Syntax

GUID()

See Also

CURSYNCNUM(), INSERT, RECNO(), ROWNUM(), PSEUDO COLUMNS, SELECT, SYNCNUM(), UPDATE

Description

The GUID() function generates and returns a 36 character unique GUID. It can be used for Primary Keys and is unique across all locations and operating systems: Windows, Mac and Linux.

Example

create table country;
 (id char(36) description "ID" default guid(),;
  countryname char(100) description "Name",;
  countrycurr char(100) description "Currency",;
  countrycap char(100) description "Capital")
create index id on country (id)
insert into country (countryname, countrycurr, countrycap);
  values ("United Kingdom","Pound sterling","London"),;
    ("United States of America","United States dollar","Washington, D.C."),;
    ("France","Euro","Paris"),;
    ("Italy","Euro","Rome"),;
    ("Germany","Euro","Berlin"),;
    ("Brazil","Brazilian real","Brasilia"),;
    ("Thailand","Thai baht","Bangkok")
select * from country