Tables > File Restructuring

Restructuring Table Fields

To comply with different needs two alternative methods are supplied to restructure table fields.

The Basic method always will preserve both the Autoinc field as type and it's value (if used at all) as well as preserving possible associated Validity Checks (MinValue, MaxValue, DefaultValue) if present at all.
Though not available as the specific values, you may have a look at the Table Properties from the Tables menu to check the number of Validity Checks.

Offering almost basically the same, the Extended method differs in that it offers setting or lifting the Required attribute for each field on the expense of clearing other possible Validity Checks as well as either re-initializing Autoinc values, or for dBASE tables converting the field into a non-auto propagating integer field depending on the current default dBASE level setting.

For most uses, the Basic method is the one recommended.