Hi Ernesto,

> > > CONSTRAINT DATOSUNO_PK PRIMARY KEY (IDDATOUNO)
> > > );
> > >
> > > CREATE UNIQUE INDEX DATOSUNO_PK ON DATOSOTIS(IDDATOUNO);
> >
> > Why are you creating a unique index? You already have a Primary Key
> > Constraint defined on IDDATOUNO - which automatically creates an index.
>
> I don't create the indices explicitly -my admin tool extracts metadata

that

> way

In that case, I suggest a different admin tool :-) ... Guess which one...


With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird & MS SQL Server.
Upscene Productions
http://www.upscene.com