DBCC CHECKIDENT

Syntax

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

Arguments

table_name

Is the name of the table for which to check the current identity value. The table specified must contain an identity column. Table names must comply with the rules for identifiers.

NORESEED

Specifies that the current identity value should not be changed.

RESEED

Specifies that the current identity value should be changed.

new_reseed_value

Is the new value to use as the current value of the identity column.

WITH NO_INFOMSGS

Suppresses all informational messages..

Examples

A. Resetting the current identity value, if it is needed

The following example resets the current identity value, if it is needed, of theEmployee table in the AdventureWorks database.

USE AdventureWorks; GO DBCC CHECKIDENT ("HumanResources.Employee"); GO

B. Reporting the current identity value

The following example reports the current identity value in the Employeetable in the AdventureWorks database, and does not correct the identity value if it is incorrect.

USE AdventureWorks; GO DBCC CHECKIDENT ("HumanResources.Employee", NORESEED); GO

C. Forcing the current identity value to 30

The following example forces the current identity value in the Employee table in the AdventureWorks database to a value of 30.

USE AdventureWorks; GO DBCC CHECKIDENT ("HumanResources.Employee", RESEED, 30); GO