How to Specifiy Primary Key Starting Number in SQL

Question

There is a table named User in database. Columns as follows:

ID
FirstName
LastName

ID is primary key and auto incremented in this case. I have only 7 records; last ID of data is 7.

How can I increment ID starting from any number (eg. 10000).

your answer is here https://forums.asp.net/t/1950215.aspx?Primary+Key+start+value+as+1000 — Naveen, Aug 29 '19 at 06:26
Possible duplicate of [SQL Server : alter the Identity seed](https://stackoverflow.com/questions/53507374/sql-server-alter-the-identity-seed) — Ed Bangga, Aug 29 '19 at 06:40

score 2 · Accepted Answer · answered Aug 29 '19 at 06:23

2

You may use this. CHECKIDENT is use to reseed the value of your identity column. For more info you may find this link.LINK.

 DBCC CHECKIDENT ('Yourtable', RESEED, yournumber);    ---- here yournumber is the number to reseed.

answered Aug 29 '19 at 06:23

DarkRob

1 Answers1