How to Reset Identity Column value after delete record

Hi,

Try to this code:

 

 

Hi 

    Refer this query for reset identity 

 

DBCC CHECKIDENT ('Emp', RESEED, 1)  

Hi Chittaranjan,

 

The DBCC CHECKIDENT management command is used to reset identity counter. The command syntax is:

DBCC CHECKIDENT (table_name [, { NORESEED | { RESEED [, new_reseed_value ]}}])
[ WITH NO_INFOMSGS ]

 

 

For Example:

DBCC CHECKIDENT ('tablename', RESEED, 0);
GO

Thanks