Hello Thierry,

Tetram Corp schrieb:

> select rc.rdb$constraint_name
> from rdb$relation_constraints rc
> inner join rdb$index_segments indexes
> on rc.rdb$index_name = indexes.rdb$index_name
> where rc.rdb$constraint_type = 'UNIQUE'
> and rc.rdb$relation_name = 'YOURTABLE'
> and indexes.rdb$field_name = 'NUMBER'
>

Thanks a million! It works fine!

It would probably be a good idea to modifiy NHibernates schema generator
to assign unique names to such constraints, the same way it is already
done for foreign key constraints.

bye,
Tobias