Constraint Doubt

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: KenA (KenA_at_discussions.microsoft.com)
Date: 06/29/04 

Date: Tue, 29 Jun 2004 15:38:02 -0700

Hi. In a table called Groups with fields GroupID (PK), Name, how can I set a Constraint to make Name filed Unique to avoid:

GroupID | Name
==========
1 | Admin
2 | Admin