SQL Server Performance Forum – Threads Archive
Reg. Identity Column Seed setting
Hi, I have a table for which the primary key is an identity column. Let us say there are 100 records in the table. Now I want some gap in the primary key values. Can I set the identity seed on the primary key to start at a higher value, say 500 (leaving the values 101 to 499 unused for the primary key column)? Thanks in advanceourspt
DBCC CHECKIDENT From Books Online:
quote:
C. Force the current identity value to 30
This example forces the current identity value in the jobs table to a value of 30. USE pubs
GO
DBCC CHECKIDENT (jobs, RESEED, 30)
GO
C. Force the current identity value to 30
This example forces the current identity value in the jobs table to a value of 30. USE pubs
GO
DBCC CHECKIDENT (jobs, RESEED, 30)
GO
MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.
DBCC CHECKIDENT(TableName,Reseed,499) Madhivanan
]]>