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 Employee
table 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 |