A key in a database table, that has no intrinsic logical meaning, and was introduced for better physical organization of the database or other technical reasons.
I was wondering what the best practices were for building and storing IDs. A few years ago, a professor told …
sql language-agnostic identity auto-increment surrogate-key