Tables > Generate SQL CREATE > Paradox: Reverse SQL CREATE

Paradox: Extracting the SQL CREATE TABLE

This is a Paradox example of a recreate SQL CREATE TABLE statement from the DBDemos employee.db table:

SQLrecreate

PdxEditor screen print: SQL CREATE TABLE for Paradox table employee.db

In the case shown specifying the Paradox compound index "ByName".

Generating the generic SQL field types, these may differ from those displayed as the native field types of the table format in focus.

The reason why "Indexes" and "Required Fields" are listed delimited by comment tags is, that BDE Local SQL cannot specify secondary indexes as part of the CREATE TABLE statement, and required fields cannot be specified by BDE Local SQL.

FLOAT vs. INTEGER

With some tables you may see figures that obviously holds integer data only, are specified as the data type FLOAT.
This is the case with older tables generated as Paradox 3.5 and 4 tables, as these versions provides only the SHORT interger type, representing a 16-bit integer type with a top limit of +32767 to -32768 (2^16 - half negatives, half positives), thus sometimes needing to switch to the FLOAT to give space for numbers exceding this limit, as e.g. the BDE Biolife.db DBDEMOS sample table.