Showing posts with label entrys. Show all posts
Showing posts with label entrys. Show all posts
Sunday, March 25, 2012
delete all data and restart key count to 0
How do I clear all the entrys from a table and make the keys start all overIf u need the current records again u can copy the records to some new table drop the identity column and create it again with the proper seed and import the data back from the temp table.|||truncate table will remove all data and reset the IDENTITY counter to the original seed
Subscribe to:
Posts (Atom)