The Snippets sidebar offers both built-in and custom snippets. The sidebar contains a select box, with My Snippets for custom snippets, and built-in options titled DB Mgmt (Database Management), SQL DDL (SQL Data Definition Language), and SQL DML (SQL Data Manipulation Language).

Snippets may be given names, and these snippets can be viewed and edited from the Snippets sidebar. To load a snippet into the SQL Query area, either choose the Snippets Insert icon or right-click on the desired snippet and choose Insert. Double-click a snippet to open an edit context, to edit the snippet body or title. This example shows two snippets, with only the first having defined a name.

Figure 6.12. SQL Editor - Snippets Palette