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

Fabric Data Days Monthly is back. Join us on March 26th for two expert-led sessions on 1) Getting Started with Fabric IQ and 2) Mapping & Spacial Analytics in Fabric. 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