General information
Forum:
Microsoft SQL Server
Category:
Database management
>If I will delete all records from the table and after it I will insert new record I will get Identity field = max + 1, but not 1...
>Why? And how to force SQL server to count Identity field from 1 again.
>
>Giedrius
I believe if you do a TRUNCATE TABLE the identity will go back to the original seed.
BOb
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only