Deleting Table Contents

[millsy007]

Hi, I want to delete the contents of my table so that when I add a new row after my auto increment index starts again at 1, how do I achieve this?

[rajivgonsalves]

use truncate

 

TRUNCATE TABLE tablename

[Gamic]

Just for completeness:

 

Sometimes you will not be able to truncate the table because there are foreign key constraints.

 

In these cases you could either drop and create the table, or delete and reset the seed:

 

  DELETE FROM tableName;

  DBCC CHECKIDENT('tableName', RESEED, 0);

[/Code]