How to reset primary key index to 1 using Visual Studio 2008 Server Explorer?

Question

Thank!

+3

B seven Aug 29 '10 at 4:47

2 answers

To reset the IDENTITY value to one, use DBCC CHECKIDENT :

DBCC CHECKIDENT (‘YOUR_TABLE_NAME_HERE’, RESEED, 1)

+10

OMG Ponies 29 . '10 5:24

p.campbell · Accepted Answer · 2010-08-29T04:57:52+0000

It looks like you have a data table and you want to restart PK Identity numbering by 1.

You will need to delete all data and reset the seed in the identity column. This can be done in one statement.

Create a new query by right-clicking on the database server or in the table and select "New query" (or any other command):

TRUNCATE TABLE MyTable;