Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Member
408 Points
132 Posts
Sep 30, 2010 07:50 PM|LINK
Alternatively, you can use DBCC CHECKIDENT like :
DBCC CHECKIDENT ("YourTable", RESEED, 0);
More info: http://msdn.microsoft.com/en-us/library/ms176057.aspx
macpak
Member
408 Points
132 Posts
Re: reset primary key to number 0...
Sep 30, 2010 07:50 PM|LINK
Alternatively, you can use DBCC CHECKIDENT like :
DBCC CHECKIDENT ("YourTable", RESEED, 0);More info: http://msdn.microsoft.com/en-us/library/ms176057.aspx