USE YourTable COPY STRUCTURE EXTENDED TO strYourTable USE strYourTable EXCLUSIVE GOTO 3 && Go to position where you want to insert the field INSERT BLANK REPLACE Field_Name WITH "FieldName",; Field_Type WITH "C",; Field_Len WITH 10,; ..... && All neccessary fields CLOSE DATABASES ALL CREATE Temptable FROM strYourTable USE TempTable APPEND FROM YourTable *** DO ALL INDEX ON Here CLOSE DATA ALL ERASE YourTable.* RENAME TempTable.DBF TO YourTable.DBF RENAME TempTable.FPT TO YourTable.FPT && If you have a Memo/GENERAL/BLOB fields RENAME TempTable.CDX TO YourTable.CDX