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

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.

A unique index is really the way to go.