TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Manish Solanki
NA
77
26k
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
Reply
Answers (
3
)
merge data table from one to another
How to get last records of employees in sql?