Subject Re: [firebird-support] Is correct to have a unique key restriction for names?
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]