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)
select identity_burn_max("t1")
t1 ------------ 51
The permission checks for identity_burn_max differ based on your granular permissions settings.
Granular Permissions | Description |
---|---|
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. |