Tracks the identity burn max value for a given table. This function returns only the value; it does not perform an update.
identity_burn_max(table_name)
is the name of the table selected.
select identity_burn_max("t1")
t1 ------------ 51
identity_burn_max tracks the identity burn max value for a given table.
The permission checks for identity_burn_max differ based on your granular permissions settings.
Granular permissions enabled |
With granular permissions enabled, you must be the table owner or have manage database permission to execute identity_burn_max. |
Granular permissions 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. |
