For most all database design I have been using the DBE in Visual Basic Express 2010 with SQL Server Compact Edition 3.5. Now I am ready to test deployment and I want to reset my database to its unused state.
This means I need to reset all the identity columns back to 0.
Is there a way to do this within VBE 2010? If so, how?
If not, what would you suggest as an alternative approach?
Thanks in advance.