MSrepl_identity_range (Transact-SQL)


Applies To: SQL Server

The MSrepl_identity_range table provides identity range management support. This table is stored in the publication, distribution and subscription databases

Column nameData typeDescription
publishersysnameThe name of the Publisher.
publisher_dbsysnameThe name of the publication database.
tablenamesysnameThe name of the table.
identity_supportintSpecifies if automatic identity range handling is enabled. 0 specifies that automatic identity range handling is not enabled.
next_seedbigintIf automatic identity range is enabled, indicates the starting point of the next range.
pub_rangebigintThe publisher identity range size.
rangebigintThe size of the consecutive identity values that would be assigned to subscribers in an adjustment.
max_identitybigintThe maximum boundary of the identity range.
thresholdintThe identity range threshold percentage.
current_maxbigintThe current max that can be assigned but not necessarily be assigned.

Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)

Community Additions