Skip to main content
Answer

automagically generated unique index for a non unique column

  • August 22, 2024
  • 1 reply
  • 37 views

Forum|alt.badge.img+6

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:
 

 

Best answer by Alban_T

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...

This topic has been closed for replies.

1 reply

Forum|alt.badge.img+6
  • Author
  • Hero
  • Answer
  • August 23, 2024

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...