Reset auto number (IDENTITY) column in SQL Server

Sometimes we need to empty table.

DELETE FROM <TABLE name>

The following code to run on it:

DBCC CHECKIDENT (<TABLE name>, RESEED, 0)

You can use truncate table only if there are no contrains and foreign keys related with this table.