How to create a UNIQUE constraint when creating a table (Enterprise Manager)

To create a UNIQUE constraint when creating a table

1. Expand a server group; then expand a server.
2. Expand Databases; then expand the database in which to create the table.
3. Right-click Tables; then click New Table....
4. In the Choose Name dialog box, enter a name for the table.
5. Fill in the columns as appropriate. Each row represents one column in the table.
6. Right-click any row; then click Properties.
7. On the Indexes/Keys tab, click New.
8. In the Column name list, select the columns that are part of the UNIQUE constraint.
9. Select Create UNIQUE to make this index a unique constraint.

See Also

Creating and Modifying UNIQUE Constraints