Reset AutoNumber(Identity Field) in Database

sql-server-ce identity
Hossein Moradinia picture Hossein Moradinia · Mar 17, 2010 · Viewed 9.9k times · Source

I Use a Sql Server Compact Edition Database File For Store the Data in My Windows Application Software.

In this database I have a table with an identity field.

When I insert a record into the Table, the identity code increments automatically. But when I delete all the records from the table, and insert some records again, the identity field doesn't start at 1.

How can I reset this value to 1?

Answer

cdonner picture cdonner · Mar 17, 2010

DBCC does not exist in CE, but you can use this instead:

ALTER TABLE t1 ALTER COLUMN id IDENTITY (1,1)

Related questions

How do you open an SDF file (SQL Server Compact Edition)?

I have an SDF file and I would like to retrieve its schema and query it with some UI. How can I do this? I have no Visual Studio installed on the machine and I would like to install as …

Read More
How to connect to SQL Server from another computer?

I want to connect from home using SQL Server 2005 to another PC. I had a look on the msd...but before connecting it says I should connect to another computer using the computer management and it didn't work out....I …

Read More
Creating stored procedure with declare and set variables

I am creating one stored procedure where only value has to pass and I have to retrieve multiple values from multiple tables. I tried to do like this but its showing errors like Incorrect Syntax near Begin and Must declare …

Read More