Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databases
reset IdentityI have an integer field set identity ON. How can I reset the identity number to 1? Thanks Anyway!
Post Follow-up to this message
RE: reset IdentityYou need to use the DBCC CHECKIDENT command. DBCC CHECKIDENT(TableName , RESEED, IdentityValue) ie. To reseed the Identity of the Employees table to 0: DBCC CHECKIDENT(employees , RESEED, 0) - Peter Ward WARDY IT Solutions "kinloan" wrote: > I have an integer field set identity ON. How can I reset the identity numb er > to 1? Thanks Anyway! >
Post Follow-up to this message
Sponsored Links
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread
