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

To add a .sql file to favorites

1. Open the SQL command file that you want to add to your favorites.

2. From the Favorites menu, choose Add To Favorites.

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

4. Click OK.

To add a connection to favorites

1. Connect to a database.

2. From the Favorites menu, choose Add To Favorites.

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

4. Click OK.

You can choose to display your favorites in a sidebar.

To show the favorites

• From the Favorites menu, choose Show Favorites.

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

To open a favorite

• From the Favorites menu, choose the favorite you want to open.