The identity column contains a unique ID number, generated by Adaptive Server, for each row in a table. Because of the way the server generates ID numbers by default, you may have large gaps in the ID numbers. The identity_gap parameter gives you control over ID numbers, and potential gaps in them, for a specific table.
This parameter can be used when creating a table with create table or select into. To change the identity gap, use identity_gap with sp_chgattribute. To see the identity gap setting for a table, use sp_help.
For details about using identity_gap, see Chapte 7, “Creating Databases and Tables” in Transact-SQL User’s Guide, the select and create table commands and sp_chgattribute system procedure descriptions in the Adaptive Server Reference Manual.
