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






  1. SQL Server / T-SQL Tutorial
  2. Sequence Indentity
  3. IDENT_SEED
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')