|
Home > Archive > Microsoft SQL Server forum > June 2005 > How to Change AutoNumber Not Start From 1
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
How to Change AutoNumber Not Start From 1
|
|
| Resant 2005-06-28, 3:23 am |
| I have a table with structure below :
Table_A
{
PGradeID int IDENTITY(1,1),
PName varchar(20)
}
If I delete all records on Table_A, and then fill some records,
PGradeID will no longer start from 1 anymore, everybody knows that. How
to change it so PGradeID will start from 1 after all records was
deleted?
Thanks b4
Resant
| |
| David Portas 2005-06-28, 3:23 am |
| Lookup the DBCC CHECKIDENT command. Also, if you TRUNCATE rather than DELETE
then the IDENTITY will be reset to seed.
Why do you care what the IDENTITY value is? It's usually fatal to attach any
significance to the value assigned by IDENTITY. If you care about the value
then IDENTITY isn't the right solution.
--
David Portas
SQL Server MVP
--
| |
| Resant 2005-06-29, 3:23 am |
| Reset identity value will not cause problem in my case, but I
appreciate your warning.
Thanks a lot, it's works!
|
|
|
|
|