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 to database 'filename'/Adding connection to the database called 'demo' to the Favorites list   Choose this option to add a favorite that contains the current 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 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 option to add a favorite that contains the contents of SQL Statements pane. The contents cannot exceed 16384 characters.

  • Name   Type a name.

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

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