Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

Add Unique and Foreign Key Constraint Support to Clustered Columnstore Indexes

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.
Status: New
Comments
fbcideas_migusr
New Member
Status changed to: New