<< Click to Display Table of Contents >> Reverse Create SQL for Table |
![]() ![]() ![]() |
This feature is available only for tables displayed via the Table View mode [(Ctrl-)DoubleClick table list or using the Show Table button].
This displays the structure and data types of some selected existing table.
The reversely generated SQL CREATE TABLE statement will be written to the currently focused SQL tab with a user selectable option of appending or overwriting the current tab contents as well as including the data itself or not in the output.
If including every option, this may be exported as a (large) text file for regeneration of the complete data table including index and validity checks in any other SQL competent database management system (DBMS).
__________________________