...

> > Why not just
> >
> > Alter Table T Drop Constraint T_PK;
> > Commit;
> > Alter Table T Add Constraint T_PK Primary Key (OldCol, NewCol);
> > Commit;
>
> What does T_PK stand for?

A 31-character name you choose for the constraint.

>
> I tried:
> alter table fuellog drop constraint INTEG_68
>
> and I get
> ISC ERROR CODE:335544351
>
> ISC ERROR MESSAGE:
> unsuccessful metadata update
> object INDEX is in use

Is the table open?

Is it possible that the system tables are already corrupted?

--
Raymond Kennington
Programming Solutions
TeamW2W (InfoPower)