Home • Database • Microsoft SQL Server
Identity column start from a specified number
Changing the Identity Seed
DBCC checkident ('Employees', reseed, 1000)
The next row inserted will begin at 1001.
Repairing the Identity Seed in case of duplication
DBCC checkident ('Employees', reseed)
Retrieving current Identity Seed
DBCC checkident ('Employees')
Share
About Author
- University
- Online Tips
- Engineering
- Programming
- General Subjects
- Science
- News
- Jobs
- Commerce
- General Knowledge
- Story, Tales & Poem
- Software Application
- Framework
- Operating System
- Database
- Networking
- Quiz
Comments 0