At 01:04 PM 28-06-02 +0100, you wrote:

>Is it possible to make a field unique without specifying an index on it?

Yes: place a UNIQUE constraint on it; and then the index will be created
automatically for you. DON'T create an additional unique index on the same
column.

heLen


All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org ·
http://users.tpg.com.au/helebor/
_______________________________________________________