Increase value of an identity column in SQL Server without dropping and recreating the table

sql-server-2008 identity
Kjensen picture Kjensen · Jun 12, 2009 · Viewed 13.6k times · Source

In a table, I have an ID column, that is an Identity int.

How can I make it so that the next row inserted will get identity 10000 (I believe this is called the identity seed) - without dropping and recreating the table?

I need to do this because of a uniqueness issue with an external service, the app accesses.

Answer

TheTXI picture TheTXI · Jun 12, 2009 
DBCC CHECKIDENT (yourtable, reseed, 9999)

This will make the next entry 10000.

Related questions

SQL Server, How to set auto increment after creating a table without data loss?

I have a table table1 in SQL server 2008 and it has records in it. I want the primary key table1_Sno column to be an auto-incrementing column. Can this be done without any data transfer or cloning of table? I …

Read More
Reuse identity value after deleting rows

Is it possible to reuse an identity field value after deleting rows in SQL Server 2008 Express? Here is an example. Suppose I have a table with an Id field as a primary key (identity). If I add five rows, I …

Read More
How can I get column names from a table in SQL Server?

I want to query the name of all columns of a table. I found how to do this in: Oracle MySQL PostgreSQL But I also need to know: how can this be done in Microsoft SQL Server (2008 in my case)?

Read More