Home Forums SQL Server 2017 SQL Server 2017 - Development Does a Unique Constraint Store the Row Identifier at the leaf level of the b-tree RE: Does a Unique Constraint Store the Row Identifier at the leaf level of the b-tree

  • April 20, 2018 at 6:21 pm

    #1987776

    UNIQUE CONSTRAINTs and UNIQUE INDEXes are implemented the same behind the scenes in SQL Server. 
    The nodes of those non-clustered constraints/indexes contain row locators to the clustered index / table data rows.  

    -Eric Isaacs