Subject RE: [ib-support] Unique fields
Author Helen Borrie
> > Is it possible to make a field unique without specifying an
> > index on it?

At 06:56 PM 28-06-02 -0400, Sean Leyne wrote:

>Technically, yes.
>Partically, no.
>You could create a trigger which would need to perform a select to
>ensure/enforce uniqueness, but if the table is large... that could end
>up being a very expensive/time consuming process.

Not just that, but it has to be reiterated that enforcing uniqueness by
trigger is not multi-user safe.

>A unique index is really the way to go.

Hmmm, well, a unique constraint, anyway.


All for Open and Open for All
Firebird Open SQL Database · ·