SQL Server/T-SQL Tutorial/Sequence Indentity/IDENT INCR

Retrieving the Seed and Increment Values

4>
5> CREATE TABLE MyTable (
6>  key_col int NOT NULL IDENTITY (1,1),
7>  abc     char(1) NOT NULL
8> )
9> INSERT INTO MyTable VALUES ("a")
10> INSERT INTO MyTable VALUES ("b")
11> INSERT INTO MyTable VALUES ("c")
12> SELECT * FROM MyTable ORDER BY key_col
13>
14>
15> SELECT
16>  IDENT_SEED ("MyTable") AS seed,
17>  IDENT_INCR ("MyTable") AS increment
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)
seed                                     increment
---------------------------------------- ----------------------------------------
                                       1                                        1
(1 rows affected)
1>

Returning an Identity Column"s Seed and Incrementing Value

The IDENT_INCR function displays the original increment value for the IDENTITY column of a specific table or referencing view.
SELECT IDENT_INCR("YourTableName") IdentIncr IdentSeed