Switch to: V9V8V7V6V5

Schema Editor - Drag and Drop

Drag and drop in the Schema Editor provides a simple visual mechanism which users can use to transfer information between and within applications. Drag and drop are similar in function to the clipboard's copy and paste mechanism.

You can use the drag and drop function for the following purposes:

  • Copy the schema objects
  • Open the database files

Copying Schema Objects

Drag and drop copying function is enabled in the Columns and Tree mode of the Schema Editor.

In a case, if dropping is possible the cursor changes its appearance. Additionally, the target object is marked with a special frame.

After dropping the objects, one or few dialogs (depending on the object types) will appear where you can apply or discard the changes.

Note: you can also drag objects between a few application windows.

Columns View

In the Columns view, you can drag one or few selected objects from one column.

Drop the objects either to the other object:

or drop at the empty space of the object list:

Tree View

In the Tree view, you can drag one or few selected objects from the schema tree:

or drag them from the object list on the right:

Drop the objects either to the other object:

or drop them at the empty space in the list:

Supported Objects

You can drag and drop objects of the following types:

  • Domain
  • Enum Localization
  • EnumValue
  • Field
  • Function
  • Index
  • KeyValue
  • Method
  • Property
  • Sequence
  • Table
  • Trigger
  • Type
  • Unique
  • View

Note: drag and drop operation is allowed for objects of the same connection kind.

After dropping the object one of the standard dialogs to will appear.

For example, in the following picture you can see the Design Table dialog opened to add a dragged field to an existing table:

Opening Database Files

A fast way to open the database file is to drag it from the file explorer and drop it to the Schema Editor.

In the columns view:

In the tree view: