Skip to main content
1 of 2
Aaron Bertrand
  • 181.5k
  • 28
  • 402
  • 619

No, there's no magic or hand-waving here. It'd be great if synonyms, say, applied to types, but that is not the case. If you want to make these columns first-class citizens, you'll need to change the table. You can automate this to some degree, though I won't post code to help with this unless you specify what you mean exactly by "manually" and why you think this will be a significant burden you want to avoid.

Aaron Bertrand
  • 181.5k
  • 28
  • 402
  • 619