3
Reply

Reset Identity after deleting all record of table

Manish Solanki

Manish Solanki

Oct 26 2015 7:32 AM
529
Hello  Everyone
   
    I have one table like  t1.
Id,name,city ,pincode this kind of column have .Id has primary key its identity key its automatically increment.this table have 10 record.i was delete this 10 record.now i will enter new record that time its id 11 bcz its auto increment. now i want that after deleting all record of table If i insert new row that it id is 1. 
so how  reset indentity after deleting all record of table 
 

Upload Source Code  Select only zip and rar file.
Answers (3)