Identity Columns

DBMS vendors usually extend SQL to allow automatic generation of unique numeric keys.

In Apache Derby, use the GENERATED ALWAYS AS IDENTITY clause.

Here is the Customer Table With Identity Column.

If the START...INCREMENT clause is omitted, values begin with 1 and are incremented by 1.

Here is the generated table: