<< Click to Display Table of Contents >> Navigation:  Tables > Generate SQL CREATE > dBASE: Reverse SQL CREATE > Recreating dBASE tables

Re-creating dBASE tables from SQL

When recreating dBASE tables via SQL, the target numerics fields will depend on both the chosen SQL commands as well as the current dBASE driver setting, where SQL SMALLINT, INTEGER and FLOAT with dBASE 7 will create fields of the type NUMERIC(6,0), LONG and DOUBLE respectively.
If you prefer recreating a true replica of the original structure equal to the original NUMERIC field specification, you may instead specify the numeric fields using the SQL DECIMAL(s,p) to create the NUMERIC type fields as desired.
The traditional dBASE Float(s,p) fields cannot be specified via SQL.
See also SQL to dBASE to SQL and SQL data type translation.

__________________________
PdxEditor Application Help, 21 May 2026; © 2010-2026 Niels Knabe