Saving SQL script files and connections in a favorites list

In Interactive SQL, you can store frequently-used SQL script files and connections in a favorites list. A favorites list is specific to a single user and cannot be seen by other users.

 Add a .sql file, SQL statements, or Connection to favorites
  1. Open the SQL script file that you want to add to your favorites.

  2. Click Favorites » Add To Favorites.

  3. Click Add the open file 'filename'. In the Name field, type a name for the sql file.

  4. Click OK.

 Add SQL statements to favorites
  1. Type the SQL statements that you want to add to your favorites in the SQL Statements pane. The contents in the SQL Statements pane cannot exceed 16384 characters.

  2. Click Favorites » Add To Favorites.

  3. Click Add SQL Statements. In the Name field, type a name for the favorite.

  4. Click OK.

 Add a connection to favorites
  1. Connect to a database.

  2. Click Favorites » Add To Favorites.

  3. Click Save The Connection Password. In the Name field, type a name for the connection.

  4. Click OK.

 Display favorites in a sidebar
  • Click Favorites » Show Favorites.

    The Favorites pane appears on the left side of the Interactive SQL window.

 Open a favorite
  • Click Favorites and choose the favorite you want to open.

 Edit a favorite
  1. Click Favorites » Show Favorites.

    The Favorites pane appears on the left side of the Interactive SQL window.

  2. Select a favorite, right-click, and then click Edit.

  3. Follow the instructions in the window.

  4. Click Save.

 See also

Sharing favorite SQL script files and connections