Code & SQL Catalog

Previous  Top  Next

The Code and SQL Catalog are easy to use places to store short pieces of code or SQL statements that you use often.

 

To make this even more easy, the SQL Catalog has a Run Item button - this button will execute the highlighted item in a new SQL Editor.

 

Items (snippets) can be arranged in groups by creating a group with the folder button, and editting an item and selecting the group from the group drop down box. Alternatively, simply drag the items to a group by using the mouse.

 

The SQL Catalog

 

Other editors have shortcuts to the SQL Catalog as well - for example, the SQL Editor has a button Create SQL Snippet - this will use the highlighted or all text in the SQL Editor window as a new SQL snippet and open up the Edit Catalog Item dialog.

 

Edit Catalog Item dialog

 

By using the Delete key when you have the Group drop down focused, you will delete the item from a group and move it to the root tree.