Fatih
Reputation: 810
How to Specifiy Primary Key Starting Number in SQL
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).
Upvotes: 0
Views: 1712
Answers (1)
Related Questions
- Determine a table's primary key using TSQL
- how to add primary key column with auto increment in sql server
- Identity column as part of primary key
- How to determine the primary key for a table in SQL Server?
- What is the statement to create a primary key in SQL like "3585c5d240dd4132bab35ab969137f3f"
- SQL Server Int primary key and Guid
- Identity on a primary key column in SQL Server
- Customize starting id in SQL Server auto-increment column
- Please tell me how to get primary key name in SQL Server 2005
- Getting autonumber primary key from MS SQL Server