Constraint Doubt

[KenA]

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

[KnooKie]

if you're using SQL Server ? Then these might help......

http://www.sqlteam.com/Forums/topic....=unique,values

http://support.microsoft.com/default...b;en-us;322002

You may want to look into triggers as well.

[KenA]

Thanks ... the http://support.microsoft.com/defaul...kb;en-us;322002 really helped