Skip to content
The latest version of DbVisualizer was released 2024-08-30DOWNLOAD HERE ->

Scripting a Table

To open the Script Table dialog, where you can insert generated text for a table in an SQL Commander editor:

  1. Select one or more table nodes in the Databases tab tree,
  2. Choose Script Table from the right-click menu.

You can also launch the dialog by dragging and dropping one or more nodes of the same type in an SQL Commander editor.

If you just want to insert the object names in the editor, hold down the Ctrl key (or the Alt key on macOS) while dragging and dropping.

This behavior can be reversed in Tool Properties, in the SQL Commander category, so that dropping without pressing a key inserts the names and pressing the key launches the dialog."

The Script dialog provides a choice of which type of statement to generate, options for formatting, use of delimited identifiers, qualified names and statement delimiters. You can also pick an open SQL Commander or a new as the destination, and where in the SQL Commander editor to insert the text.