The IDENT_SEED function displays the originally defined seed value for the IDENTITY column of a specific table or referencing view. : IDENT_SEED « Sequence Indentity « SQL Server / T-SQL Tutorial






SELECT IDENT_SEED('YourTableName') IdentSeed
15.6.IDENT_SEED
15.6.1.The IDENT_SEED function displays the originally defined seed value for the IDENTITY column of a specific table or referencing view.
15.6.2.Identity Property: SELECT IDENT_SEED('customer'), IDENT_INCR('customer')