Resetting Primary Key counter in SQL Server

2 07 2007

To reseed/reset the IDENTITY column of an SQL Server table, run the following in Query Analyzer or SQL Server Management Studio:

DBCC CHECKIDENT (Table_Name, RESEED, 1)

Peace!

« »


Actions

Informations

Leave a comment

You can use these tags : <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>