Manish Solanki

Manish Solanki

  • NA
  • 77
  • 24.4k

Reset Identity after deleting all record of table

Oct 26 2015 7:32 AM
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 
 

Answers (3)