Skip to main content

I have a problem with a unique nonclusterd index that is automagically added when I run Create:
 

I can't figure out why this is added as the referenced column “ikc_name” doesn't need to be unique:
 

 

It turns out a former colleague of mine added a control procedure to the Dynamic model that would automagically add unique constraints to all columnnames in a table that end with ‘_name’….

Note sure I like that one...