Reverse Create SQL for Table

<< Click to Display Table of Contents >>

Navigation:  Menus > Analyse >

Reverse Create SQL for Table

Previous pageReturn to chapter overviewNext page

SQL structure of existing tables

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.

SQL table structure for external DBMS

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).

__________________________
AbsoluteSQL Application Manual - 21 February 2024 - Copyright © 2011 - 2024 Niels Knabe