Another traditional way is to use a trigger to generate the surrogate key.
⇑ Translate the sentence above by Google ⇑
Related: surrogate
Prev: A simple example is to have a numeric surrogate column.
Next: It can be used to generate unique values for the surrogate key column.
