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)

See Also

Expressions

System Functions