delete from table

[BobBob10]

When I delete from a table without setting the where clause, everything is deleted. However, when I insert into the table again the identity starts where it left off and not at 1 again.

Does anyone know how to stop this?

 

[SQLDenis]

2 ways
1 use truncate table instead, this also will be much faster than a delete operation


2
DBCC CHECKIDENT (TableName, RESEED, 1)


Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[BobBob10]

cheers

Bob