TranID Column

The _tranid special column contains a unique 64-bit transaction identifier. You can specify the _tranid special column as an additional primary key in historical tables.