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 favoritesOpen 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 SQL statements to favoritesType 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.
From the Favorites menu, choose Add To Favorites.
Select Add SQL Statements. In the Name field, type a name for the favorite.
Click OK.
To add a connection to favoritesConnect 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.
To display favorites in a sidebarFrom the Favorites menu, choose Show Favorites.
The Favorites pane appears on the left side of the Interactive SQL window.
To open a favoriteFrom the Favorites menu, choose the favorite you want to open.
To edit a favoriteFrom the Favorites menu, choose Show Favorites.
The Favorites pane appears on the left side of the Interactive SQL window.
Select a favorite, right-click, and then choose Edit.
Follow the instructions in the window.
Click Save.
See also |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |