·By object name - displays objects where the name starts with the specified valueBrowsing Data

Click the Browse Data node to browse the first few records in a table or view. The default number of records displayed is 100; however, this value can be changed in the WinSQL Professional configuration options.

Tip: Double-click the header of any row to sort the data by that row.

Using the Quick Math Feature

The Quick Math feature allows you to quickly perform basic math calculations on numeric fields displayed in a query result grid.

Perform the follow steps to use the Quick Math function:

1          Log into WinSQL and establish a database connection. For more information, see “Establishing a Database Connection.”

2          Click the Catalog Details tab.

3          Click the plus sign by Tables.

4          Click the plus sign by the desired table.

5          Click Browse Data.

6          Select at least two rows from the result grid that represent numeric data.

WinSQL displays a Quick Math popup window displaying a sum, minimum, maximum and average values for the selected rows.

The Quick Math window displays for approximately eight seconds. Repeat step 6 to display the Quick Math window again.