The MSrepl_identity_range table provides identity range management support. This table is stored in the publication, distribution and subscription databases
| Column name | Data type | Description |
|---|---|---|
| publisher | sysname | Name of the Publisher. |
| publisher_db | sysname | Name of the publication database. |
| tablename | sysname | Name of the table. |
| identity_support | int | Specifies if automatic identity range handling is enabled. 0 specifies that automatic identity range handling is not enabled. |
| next_seed | bigint | If automatic identity range is enabled, indicates the starting point of the next range. |
| pub_range | bigint | Publisher identity range size. |
| range | bigint | The size of the consecutive identity values that would be assigned to subscribers in an adjustment. |
| max_identity | bigint | Maximum boundary of the identity range. |
| threshold | int | Identity range threshold percentage. |
| current_max | bigint | Current max that can be assigned but not necessarily be assigned. |