identity_burn_max

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

Syntax

identity_burn_max(table_name)

Parameters

Examples

Permissions

The permission checks for identity_burn_max differ based on your granular permissions settings.

Granular PermissionsDescription
Enabled

With granular permissions enabled, you must be the table owner or have manage database permission to execute identity_burn_max.

Disabled

With granular permissions disabled, you must be the database owner or table owner, or be a user with sa_role to execute identity_burn_max.