identity_burn_max

Description

Tracks the identity burn max value for a given table. This function only returns the value and does not do 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. This function only returns the value and does not do an update.

Permissions

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