Create Table and Modify Table dialogs
Upper part: GUI
The upper part of the dialog provides a GUI for defining the table structure, and associated constraints and indexes.
SQL Script
The pane under SQL Script shows the statement or statements to be run to achieve the result you have specified using the GUI.
You can use this pane just as a preview. You can also edit the statement or statements right there.
Options
Item | Description |
---|---|
Execute in database | Change data structure in your database by running the statement or statements. Execute. Execute the statements right away. If associated changes in database consoles are possible, the corresponding preview is shown. See Previewing changes. Preview. Preview potential associated changes prior to executing the statements. |
Replace existing DDL | Replace the definition (usually, a CREATE statement) in the corresponding database console or SQL file with the statements shown under SQL Script. Replace. Perform the replacement right away. If associated changes are possible, the corresponding preview is shown. Preview. Preview potential associated changes prior to performing the replacement. |
Open in editor | Copy the statements into the corresponding database console or SQL file.
To Editor. Switch to the corresponding editor tab right away. If associated changes are possible, the corresponding preview is shown prior to copying the statements. Preview. Preview potential associated changes. |