IDENT_SEED
Returns the seed value (returned as numeric(@@MAXPRECISION,0)) specified during the creation of an identity column in a table or a view that has an identity column.
Syntax
IDENT_SEED ( 'table_or_view' )
Arguments
'table_or_view'
Is an expression specifying the table or view to check for a valid identity seed value. table_or_view can be a character string constant enclosed in quotation marks, a variable, a function, or a column name. table_or_view is char, nchar, varchar, or nvarchar.
Return Types
numeric
Examples
This example returns 1 for the jobs table in the pubs database because the jobs table includes an identity column with a seed value of 1.
USE pubs
SELECT TABLE_NAME, IDENT_SEED(TABLE_NAME) AS IDENT_SEED
FROM INFORMATION_SCHEMA.TABLES
WHERE IDENT_SEED(TABLE_NAME) IS NOT NULL
Here is the result set:
TABLE_NAME IDENT_SEED
------------------------------------------------------------ -----------
jobs 1
(1 row(s) affected)