If you need to enforce a column to have unique values, there are a couple of choices you have to enforce that. One is the UNIQUE constraint, and the other is to make the column a primary key.
While both of them will do the job, there's a difference between them. A UNIQUE constraint will allow you to have a NULL value, but a primary key won't. This is important to remember when you're designing your tables.
Take advantage of special member promotions, everyday discounts, quick access to saved content, and more! Join Today.