IDENT_SEED function returns the seed value of an identity column specified while creating a table or view.
Syntax of IDENT_SEED Function :
IDENT_SEED ('table_or_view)
table_or_view is a table or view name. It can be of type char, nchar, varchar or nvarchar
Return type of IDENT_SEED function is a numeric.
Examples of IDENT_SEED Function :
Example 1 : Use of IDENT_SEED function in select clause
SELECT IDENT_SEED ('User')
Output
1
Above example returns seed value 1 of an identity column in User table.