Using favorites

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

Open the SQL command file that you want to add to your favorites.
From the Favorites menu, choose Add To Favorites.
Select Add the open file 'filename'. In the Name field, type a name for the .sql file.
Click OK.

To add a connection to favorites

Connect to a database.
From the Favorites menu, choose Add To Favorites.
Select Save The Connection Password. In the Name field, type a name for the connection.
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.

Send feedback about this page via email or DocCommentXchange