sql server 2008

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

I'm developing a website, it is on testing.

I have one problem.

I set my "id" field as auto incremented by 1 when I delete all data from the database, again I add data to the database then "id" field starts from next to the last "id".

Suppose 20 before deletion after deletion 21

I want to start again from 1 after deleting all data.

Posted 27-Nov-10 10:02am

somendra chaudhary

Updated 27-Nov-10 10:10am

Henry Minute

v2

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Henry Minute · Answer 1 · 2010-11-27T10:12:00

Solution 2

You can do this using SQServer Management Studio as outlined in this article[^].

Although if your website is still in development, why bother?

Posted 27-Nov-10 10:12am

Henry Minute

Vivek Johari · Answer 2 · 2010-11-28T18:24:00

Hi Somendra,
If you want to start again from 1 after deleting all data, then instead of using "Delete" command you should use the "Truncate" command as it done both the works, deleting all the records and resets the Identity property to its initial value which is in your case is 1.
you can see the difference between the "Delete" and "Truncate" command here Difference between Delete and Truncate command

But if you want to use only the "Delete" command, then you can reset the identity property.For reset the identity property, you can see the following article on Code project.
Identity property in Sql Server

Please let me know if you have any query regarding my answer.

Regards
Vivek Johari

Not Active · Answer 3 · 2010-11-27T10:08:00

Solution 1

That is not how the field operates. To do as you wish you would need to implement some complex logic to find the next available ID, but then it wouldn't be an autoincremented field any longer. IDs are general internal references, what does it matter if it starts at 21 rather than 1 ?

Posted 27-Nov-10 10:08am

Not Active

Updated 27-Nov-10 10:09am

v2