Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 (Français) » SQL Anywhere Server - Database Administration » Administering your database » SQL Anywhere graphical administration tools » Using Interactive SQL » Recalling commands

 

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, SQL statements, or Connection 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 SQL statements to favorites
  1. Type the SQL commands 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. From the Favorites menu, choose Add To Favorites.

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

  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.

 ♦  To display favorites in a sidebar
  • 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.

 ♦  To edit a favorite
  1. From the Favorites menu, choose Show Favorites.

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

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

  3. Follow the instructions in the window.

  4. Click Save.

 See also

Sharing Favorites