IDENT_INCR

Contents

IDENT_INCR#

Returns the declared increment of a table’s identity column, from Querona metadata. Returns NULL when the table has no identity column.

Syntax#

IDENT_INCR ( 'table' )

Arguments#

‘table’: The name of the table, as a string.

Return types#

decimal(28,0)

Example#

CREATE TABLE dbo.Product (
    Id   int          IDENTITY(1000, 10) PRIMARY KEY,
    Code nvarchar(20) NOT NULL
);

SELECT IDENT_INCR('dbo.Product');   -- 10

See Also#