DBCC CHECKIDENT

We can find the current identity seed by using DBCC checkident .

DBCC checkident (#a)

if we execute above query than we will find like below:
Checking identity information: current identity value 'some number', current column value 'some number'.

DBCC CHECKIDENT ('tablename', 'RESEED', rowid)

Ex:DBCC CHECKIDENT ('IC_Request', 'RESEED', 2)

 

'table_name'

It Is the name of the table for which to check the current identity value .

RESEED

Specifies that the current identity value should be corrected.