6.1.4.1 Snippets tab

The Snippets tab, which is a tab in the SQL Additions sidebar, offers both built-in and custom snippets. The tab 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 tab. 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.4 SQL Editor - Snippets Palette

SQL Editor - Snippets Sidebar