Add to Favorites window

Favorites can be added for the current database connection and for the currently open SQL file.

This window changes slightly depending upon whether you are connected to a database and/or you have a SQL file open. This window has the following components:

  • Add The Current Connection   Choose this option to add a favorite that contains the connection information of the currently connected database.

    • Save the connection password   Choose this option to include the password in the favorite. Otherwise, when you run this favorite, you will be prompted to enter the password.

  • Add the open file filename.sql   Choose this option to add a favorite that contains the contents of the currently open SQL file. This option appears only if a SQL file is currently opened in Interactive SQL.

  • Add SQL statements   Choose this option to add a favorite that contains the contents of the SQL Statements pane. The contents cannot exceed 16384 characters.

  • Name   Type a name.

  • Create In   Choose an existing directory or click New Folder to create a new directory to save the favorite in.

    Favorites are specific to a given user on a given computer; they cannot be shared.