Posted by David Portas on 12/28/05 17:15

David Portas wrote:

> Cecil wrote:
>
> > >>I don't see the purpose of the ID column? Why not make the name the primary
> > >>key?
> >
> > I was thinking of doing that, but I intend for the Logon table to be
> > like an ID card. Only for efficient identification. I wanted to reuse
> > this table design in multiple projects that would require
> > authentication.
> >
>
> Name would still be unique though wouldn't it? So it should still have
> a unique constraint on name.
>

Apologies, I see that you have declared a unique INDEX on name. A
unique CONSTRAINT is virtually equivalent however and is usually the
preferred choice rather than an index.

--
David Portas
SQL Server MVP
--

[Back to original message]