In this example the starting value for IDENTITY is 1, and it will increment by 1 for each new row.
A specification of IDENTITY(10,10) gives a start value of 10, and will increment by 10 for each new row.

PostgreSQL

In PostgreSQL RDMS you can enter SERIAL as type of the selected column.