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:
Post Comments (Atom)
No comments:
Post a Comment