<< I do want to remove it from all tables that have the RecordBy column. Do I need to unload structure from each table. >>
No, you can rename and change the definition in one operation: ALTER TABLE Table1 ALTER COLUMN RecordBy TO RecordBy1 INTEGER NOCHECK ALTER TABLE Table2 ALTER COLUMN RecordBy TO RecordBy1 INTEGER NOCHECK (Do all tables here) RENAME COLUMN RecordBy1 to RecordBy IN Table1 NOCHECK RENAME COLUMN RecordBy1 to RecordBy IN Table2 NOCHECK (Do all tables here) The ability to specify NOCHECK on ALTER TABLE is a fairly recent addition. You definitely want NOCHECK, otherwise each command will have to parse all the forms and reports looking for references to update (which is pointless because at the end of the operations the columns will have the original name). For older versions, you need to first RENAME the columns with NOCHECK, then ALTER their definitions. -- Larry
