Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » UltraLite - Database Management and Reference » UltraLite as a MobiLink client » UltraLite clients


Primary key uniqueness in UltraLite

UltraLite can maintain primary key uniqueness using any of the techniques supported by MobiLink.

One of these methods is to use a GLOBAL AUTOINCREMENT column. GLOBAL AUTOINCREMENT is similar to AUTOINCREMENT, except that the domain is partitioned. UltraLite supplies column values only from the partition assigned to the database's global database ID. Each UltraLite database is assigned a unique integer global database ID.

A second method is to use a UUID primary key column. A UUID requires more data, but needs no distinct database identifier.

 See also

Methods for finding the last assigned GLOBAL AUTOINCREMENT value
Partition sizes