Carlos,

> Is it possible to combine a Foreign Key + a Unique Constraint to avoid
> duplicate index ?
>
> ALTER TABLE SVCs_Batch ADD
> CONSTRAINT RF_SVCs_Batch2XDRs_Batch
> FOREIGN KEY (Id_XDRs_Batch) REFERENCES XDRs_Batch(Id_XDRs_Batch)
> using *UNIQUE* index FK_SVCs_Batch_XDRs_BATCH;
>
> this is not (yet) accepted !

Vote for it:
http://tracker.firebirdsql.org/browse/CORE-651


--
With regards,
Thomas Steinmaurer
http://www.upscene.com/