9

Is it possible to reset the identity column in a compact database? I'm finding lots of answers regarding standard SQL Server, but no definitive answer regarding if it is possible using SQL CE.

Dropping and recreating the table is not ideal in my scenario!

Uwe Keim
  • 39,551
  • 56
  • 175
  • 291
Mike Baxter
  • 6,868
  • 17
  • 67
  • 115

1 Answers1

20
ALTER TABLE [MyTable] ALTER COLUMN [Id] IDENTITY (1,1)
ErikEJ
  • 40,951
  • 5
  • 75
  • 115