Truncate Table vs. DELETE FROM April 21 2006
Just a quick note that instead of deleting all the rows from a table you can also use the “TRUNCATE TABLE” command. This command has the added benefit of resetting the IDENTITY columns back to its seed value.
In other words, automatic primary keys start back at 1.
- Posted in : General
- Author : site admin
Comments»
no comments yet - be the first?