Unique Index

Written by

If I run the following, what will happen?

CREATE TABLE myTable (someField int, UNIQUE (someField));
INSERT INTO myTable VALUES (null);
INSERT INTO myTable VALUES (NULL);

Answer: Two rows containing NULL will be inserted. NULL’s might be unique, so the unique index allows multiple.

Comments