The syntax is:
create table table_name (column_name datatype(constant_expression) identity) with identity_gap = value
For example:
create table mytable (IdNum numeric(12,0) identity) with identity_gap = 10
This statement creates a table named mytable with an identity column. The identity gap is set to 10, which means ID numbers will be allocated in memory in blocks of ten. If the server fails or is shut down with no wait, the maximum gap between the last ID number assigned to a row and the next ID number assigned to a row is ten numbers.
