View menu is mainly used to change objects appearance in Object browser. It provides different options to view tables and databases' sorting. You can also create your own entity filters to choose from and view user's and server's query history to gain access to even more detailed information about the user and the server. 



Here is the list of all the functions you can access via Edit menu.

1. Quoted Identifiers - adds quotation marks ("") to each identifier (databases, tables, etc.)


2. Entity Schema - displays objects' entity schema in object browser.


3. Group by Schema - groups object by entity schema in object browser.


4. Sort Columns Alphabetically - displays columns alphabetically in object browser.


5. Entity Filter - allows you to manage Entity filters and create new ones. To create your own filter select Mange Filters from View >> Entity Filter menu. 'Manage Schema Filters' window will pop-up. Click 'New'.

In 'Schema Filter Properties' window you will be prompted to enter Filter Name, Logical Operation (Or, And) and Conditions. To create new conditions click 'New' button. 'Filter Condition Properties' window will pop-up. Choose desired Filter Field, Criteria, enter the Filter Value and check 'Ignore case' check-box if you want the Filter's case to be ignored. Click 'OK' twice, to go back to 'Manage Schema Filters' window and verify the filter with proper filter value was added to the list. Click 'OK'. (On the picture above, a user created four filters. The selected filter's parameters are shown under the Filter list, the are:  (<Schema> STARTS WITH "quarter" (nocase)) ).
 
To apply your criteria to object browser open View >> Entity Filter >> Select  and select the created filter. Refresh the database. If you want to cancel the effect select 'None' from View >> Entity Filter.
Note: Filters will not be applied to the object browser unless you right click on the database and select 'Refresh Databases'!

   6.  User Query History - opens a connected user's Query History. The application keeps a history of your queries issued from the current workstation. The data is stored on the user's PC. This option is useful if you need to know if a certain SQL command/query was executed by the current user. The main workspace of the window initially contains a list that represents all user queries issued from your current workstation. When a history record is highlighted, you can see the full query at the bottom of the window.



Use the filtering fields on the top to filter the list by specific criteria. Using the Find field, you can also filter out records that contain specific text. To sort the list by a specific column in ascending or descending order, click the column header once or twice.
The number of records in the history is defined in the application settings. To set this number, click Tools >> Options in the top menu, go to Query Analyzer >> Defaults settings section and enter the desired value under Keep [number] user queries in history.

   7.  Server Query History - opens a History of all executed queries on the server. The data is stored on the server. You can choose the following search parameters from the tool bar: Database, User, How many rows to show, the duration of the query and Date range and sort the data according to the selected parameters.
 
   8.  Toggle Object Browser - toggles the object browser on and off.








Go up  |  Go To WorkBench Help page