On rare occasions, an issue may arise where modifying records in a table corrupts the data file. A way to deal with this issue is to simply delete and recreate the table. The new table would need to match the original table exactly (e.g. table name, field names, field types, relations, etc.). The original table may be easily duplicated by using the copy/paste feature in Structure.

Since deleting the table will also delete all of its records, it’s a good idea to export the data first by going to File > Export and selecting the “Data to file…” option. Then, once the table is recreated, the records can be put back by using the “Import data from file…” option.

NOTE: Any references to the old table number in methods would have to be updated to the new table number. References to the table name in methods will be deleted when the original table is deleted, but will be put back by 4D when the table is recreated.