DBCC CHECKIDENT ('table_name', NORESEED)
6> CREATE TABLE MyTable (
7> key_col int NOT NULL IDENTITY (1,1),
8> abc char(1) NOT NULL
9> )
10> INSERT INTO MyTable VALUES ('a')
11> INSERT INTO MyTable VALUES ('b')
12> INSERT INTO MyTable VALUES ('c')
13> SELECT * FROM MyTable ORDER BY key_col
14>
15>
16> --Retrieving the Current IDENTITY Value of the Table MyTable and Its Correct Value
17> DBCC CHECKIDENT ('MyTable', NORESEED)
18>
19> drop table MyTable
20> GO
(1 rows affected)
(1 rows affected)
(1 rows affected)
key_col abc
----------- ---
1 a
2 b
3 c
(3 rows affected)
Checking identity information: current identity value '3', current column value '3'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
1>