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')
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
- Generic ERP
Comments 0