Foxhound is the better* Database Monitor for SQL Anywhere.
*better: More thorough, more relevant, more effective.
...more Alerts, more All Clears, more details, more control in your hands.

Breck Carter
Last modified: October 6, 1997
mail to:

Generate Surrogate Keys

The code for generating surrogate or artificial primary keys has been implemented to address some of the difficulties described in Intelligent Versus Surrogate Keys.

Click here to download

The function f_get_next_surrogate_id takes 4 parameters:

For more documentation refer to the code itself.

See also: Intelligent Versus Surrogate Keys.
Breck Carter can be reached by phone at (416) 763-5200 or via email at