Saving SQL queries as stored queries

SQL queries can be saved for reuse. The SQL queries are saved as a stored query, a type of database object. Stored queries are stored within stored query groups.

To save a SQL query as a new stored query:

  1. Make sure that a stored query group exists in the model group tree.
  2. Create a SQL query.
  3. On the SQL dialog, click Save As.

    This opens the Save As dialog.

  4. In the box at the top of the dialog, enter a name for the stored query.
  5. In the Master Database tree, select the stored query group in which you want to save the stored query.
  6. Click Save.

Tips:


SQL and stored queries