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

Retrieving the Seed and Increment Values

   <source lang="sql">

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></source>

Returning an Identity Column"s Seed and Incrementing Value

   <source lang="sql">

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</source>