Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
3
Reply
Reset Identity after deleting all record of table
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
Reply
Upload Source Code
Select only zip and rar file.
Post
Reset
Answers (
3
)
merge data table from one to another
How to get last records of employees in sql?