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.