Mike Baxter
Reputation: 7268
Reseed identity column in SQL Compact
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!
Upvotes: 9
Views: 6976
Answers (1)
Related Questions
- reseed sql server identity columns
- Reseed identity column in other database (not in database which is currently in use)
- How to reseed the identity column in SQL Server?
- How can I reseed an identity column in a T-SQL table variable?
- Reseed back 1 with existing data in SQL Server
- Reseeding Identity Column to Original Value
- SQL Server: Regenerate value for identity column on row update
- How to reseed/replace identity columns on existing data
- RESEED identity columns on the database
- Reseeding the Identity column for new records only (SQL)