No Duplicates

Archived Topics
1

Is it possible to set a column to no duplicates values like you can in Access?

2

You bet! This is done by adding a unique index on that column. How to do this varies slightly by database vendor, but something like this should work:

ALTER TABLE mytable ADD UNIQUE INDEX (mycolumn)

Hope this helps,