News for hackers. Stuff that matters.

A comment on SQL X-to-Y. Parent comment

Re:SQL X-to-Y by dspillett on Monday November 02, 2020 @05:05AM (#24966361)
I've seen alternate used in other places to refer to candidate keys that are not currently the primary key, though I'm fairly sure it isn't a defined standard term.
[ Parent | on HN ]
Re:SQL X-to-Y by panda17 on Tuesday November 03, 2020 @03:33PM (#24983663)
Regarding the "industry term", search:

   site:oracle.com "alternate key"

   site:microsoft.com "alternate key"

   site:ibm.com "alternate key"
[ Parent | on HN ]
Re:SQL X-to-Y by dspillett on Tuesday November 03, 2020 @07:47PM (#24985701)
"defined standard" !== "industry term", though I accept your point that it appears to be more common than I was thinking.

IIRC it wasn't introduced to me when learning databases academically which I was assuming to be a standards compliant environment, but that was quite some years ago so I may or may not R C...

[ Parent | on HN ]