To change the identity gap for a specific table, use sp_chgattribute:
sp_chgattribute "table_name", "identity_gap", set_number
where:
table_name is the name of the table for which you want to change the identity gap.
identity_gap indicates that you want to change the identity gap.
set_number is the new size of the identity gap.
For example:
sp_chgattribute "mytable", "identity_gap", 20
To change mytable to use the identity burning set factor setting instead of the identity_gap setting, set identity_gap to 0:
sp_chgattribute "mytable", "identity_gap", 0
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
