A question I’ve seen asked time and again in forums and from DB developers is “What’s the difference between a unique constraint and a unique index?”. So I thought I’d do a quick write up explaining the differences. Foreign Keys Allows Nulls Also Creates… Unique Constraint ✔️ ✔️ Unique Index Unique Index ❌ ❌ … Continue reading Unique Index Versus Unique Constraint