Create constraints for lastname, firstname and middlename

[Yosh_]

Hi guys, i'm kinda new in using MSSQL. I'm using MSSQL Server 2005. I've created the primary key on a field that auto generates. However, i need to disallow the same name inputed again. I think i might have to write a t-sql statement on the table. But i really don't know how to go about it. Pls help. How can i achieve this?

He who goes for revenge must first dig two graves.

[Lost User]

Creamboy wrote:

However, i need to disallow the same name inputed again.

That would be a Unique Constraint, somewhat similar to this example;

ALTER TABLE [MyTable]
ADD CONSTRAINT [UniqueConstraintName]
UNIQUE (ColumnValue)

I are Troll :suss: