Subject Re: [firebird-support] Is correct to have a unique key restriction for names?
Author W O
Hello Alexandre

Of course that no with people's names, just with control tables like
Countries or States which never have duplicates.

Greetings.

Walter.



On Sun, Aug 14, 2011 at 11:03 PM, Alexandre Benson Smith <
iblist@...> wrote:

> **
>
>
> Em 14/8/2011 23:43, W O escreveu:
>
> > Hello everybody
> >
> > I had unique key restrictions on the column "Name" of tables like:
> > Countries, States, Banks, etc.
> >
> > So, I can avoid duplicates.
> >
> > What do you think, is it correct to use unique keys for that job?
> >
> > Greetings.
> >
> > Walter.
> >
>
> It depends on the business rules...
>
> I don't think that a unique constraint on the Field Name of a table of
> people is ok.
>
> We al lknow that there is more than one John Smith in the world.
>
> see you !
>
>
>


[Non-text portions of this message have been removed]