SQL Catalogs

SQL Catalogs help you store your SQL code for later. Create as many catalogs as you want.

The drop-down box displays the names of the SQL code in the currently loaded Catalog.

	New Catalog
	Open Catalog
	New SQL
	Open SQL
	Save SQL & Catalog
	Delete SQL from Catalog

How to Use

• New Catalog
  1. Click the New Catalog button to use a new catalog
  2. Enter SQL into the editor window
  3. Click the Save SQL and Catalog button
     • If catalog is not already save you will be asked to save it first
     • The you will be ask to name your SQL statement
     • The name will then appear in the SQL drop-down list
  4. Use the drop-down list to quick recall saved statements


• Open Catalog
  1. Click the Open Catalog button
  2. Find a catalog file and click open
  3. The drop-down list now contains all the statement names in the catalog


• Add SQL to Catalog
  1. Click the New SQL button
  2. Enter SQL statement into the editor window
  3. Click Save SQL and Catalog Button to save changes


• Edit SQL in Catalog
  1. Select a statement name from the drop-down list
  2. Modify the statement in the editor window
  3. Click Save SQL and Catalog Button to save changes


• Open SQL
  1. Click the Open SQL button
  2. This will replace when is in the sql window


• Delete SQL in Catalog
  1. Select a statement name from the drop-down list
  2. Click Delete SQL from Catalog Button