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.
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.
| 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. |
- Modify existing objects. In the generated set of statements,
ALTER statements are preferred to
- Create modified objects. The changes you have made using the GUI are translated into a minimal set of
CREATE and other statements.
- Create all objects. The generated set always includes the
CREATE TABLE statement, as if the whole table were created anew.
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.
Last modified: 9 August 2017