Reset id's in SQL?

General Computing Microsoft Windows
1

If I’ve emptied a database, can I force it to start auto counting id’s from 1 again?

Sent from my Nexus One using Tapatalk

2

alter table {tablename} auto_increment = 1;

DT.

3

or…

DBCC CHECKIDENT ([tablename], reseed, [seed number])

and to check what the current value is…

select ident_current(‘tablename’)