Skip to main content
Solved

automagically generated unique index for a non unique column

  • August 22, 2024
  • 1 reply
  • 29 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...

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

Forum|alt.badge.img+6
  • Captain
  • 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...


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings