SQLEditor Icon

The Object Palette

The object palette contains template objects that can be dragged to the document window.

It is located in the lower right corner of the main document window in the Object Sidebar


It can be hidden by dragging the vertical resize bar to the bottom of the window
or revealed by dragging this bar vertically up from the bottom of the window.

When you first start SQLEditor there are object templates for the three basic object types (tables, comments and fields/columns).

You can then add custom templates for objects and groups of objects.
The object palette is shared between documents and is an easy way to keep reusable parts to hand.



Template Action Menu

There is a popup menu on the bottom left of the panel

New from Clipboard

This will create a new template from the current contents of the clipboard (if possible)

Duplicate

This will duplicate the currently selected template

Delete Selected

This will delete the currently selected template

Using a palette template

  1. Scroll the document to the required location
  2. Drag the template to the document window
    A new object will appear in the document window.

Note that the new object name may change slightly depending on the objects currently in the document

Adding templates to the palette

  1. Create the new template in a SQLEditor document.
  2. Select all of the objects that you want in the new template
  3. Hold option and then drag the objects to the palette
    The new palette entry should appear

Alternatively you can use the clipboard instead

  1. Create the new template in a SQLEditor document.
  2. Select all of the objects that you want in the new template
  3. Use Edit→Copy
  4. Click on the gear icon in the object palette
  5. Choose New from clipboard
    The new palette entry should appear

Removing a template

Warning

The object palette is shared between all documents and the data is stored in your user preferences.

Deleting a template will remove it for all documents.

You can remove templates that you have added. However the built in templates (currently tables, fields and comments) cannot be removed

  1. Click the template that you wish to delete
  2. Click on the Palette Action Button (the gear icon)
  3. In the menu choose Delete Selected
    The entry should disappear