Skip to main content

    BI in SQL vNext

    New

    Add Unique and Foreign Key Constraint Support to Clustered Columnstore Indexes

    Vote (12) Share
    Jakub Kaczanowski's profile image

    Jakub Kaczanowski on 11 Apr 2015 11:34:37

    Posted on connect but just putting here as well: https://connect.microsoft.com/SQLServer/feedback/details/1031466/constraints-on-clustered-column-store-indexes

    Currently clustered columnstore indexed tables only support not null constraints. Unique and foreign key (even unenforced - just for metadata purposes) are required for these to be considered "rea" relational tables. I don't want to have to manually code in a unique constraint check every time I insert or update a CCI table.