The Unique Constraint Editor allows you to setup a unique index on a column or group of columns.
This type of constraint works similar to a Primary Key by not allowing duplicates.
A Unique Constraint is handy for use with MS Access Front ends. MS Access 97 at least does not like Primary Keys that are none integer, so you can make all your tables that Access uses have a serial recID field and a UC to enforce uniqueness.
This type of constraint cannot be edited, and if you need to make changes you must drop it and recreate it.
To add columns you simply have to check them off. |
||
|
|
See also: