Returning an Identity Column's Seed and Incrementing Value : IDENT_INCR « Sequence Indentity « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. Sequence Indentity
  3. IDENT_INCR
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
15.5.IDENT_INCR
15.5.1.Returning an Identity Column's Seed and Incrementing Value
15.5.2.Retrieving the Seed and Increment Values