Learn more about Toad for SQL Server
at Quest.com

Find solutions and downloads at the
Toad for SQL Server Support Portal

< To bookmark a page, right-click the Page Title and select Add to Favorites / Bookmark This Page

Toad for SQL Server 5.7

You are here: Work with Data > Table Browser

Table Browser

Use the Table Browser to browse table data or display data from an XML Schema Definition (.xsd) file.

The Table Browser consists of the following:

Collapsible query pane, where you can enter queries to select data in the table
Data grid that displays the results of the query

To view data in the Table Browser

Right-click a data grid and select Send To | Table Browser to open the data in a new Table Browser window.

Use Queries

Use the top, collapsible pane of the Table Browser to enter queries to limit the data displayed. You can enter and execute one or more SELECT statements.

To execute a query

Enter the query in the top, collapsible pane of the Table Browser.
Click in the Table Browser toolbar (F9).

If the query window contains multiple SELECT statements, the data retrieved by the last statement is displayed. You can view the results of a different SELECT statement by selecting the appropriate statement from the drop-down list in the Table Browser toolbar.

Note: The Table Browser query pane shares many of the features of the Editor. Many configuration settings and features available to the Editor also apply to the query pane in the Table Browser. For example:

You can copy Code Snippets into the query pane.

You can use shortcut keys to perform frequently used actions. See Editor Shortcut Keys for more information.