If you want to enforce uniqueness on the column you must include the appropriate constraint too.
If you wish to ensure one-of-a-kind values in a column, you must also include the suitable constraint as well.