identity_burn_max

Description

Tracks the identity burn max value for a given table. This function returns only the value; does not perform an update.

Syntax

identity_burn_max(table_name)

Parameters

table_name

is the name of the table selected.

Examples

Example 1

select identity_burn_max("t1")
t1
------------
51

Usage

identity_burn_max tracks the identity burn max value for a given table.

Permissions

Only the table owner, System Administrator, or database administrator can issue this command.