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