Previewing Table Data from the Table Form
- In the Catalog Explorer, double-click the
Table Definitions node.
The catalog's table definitions are displayed.
- Double-click the required table definition.
The table definition is displayed.
- Click
(Preview Table Data).
The <table-name> data tab is displayed showing a preview of how the table would look in an ODBC-enabled application.
- Use the following tools to further manipulate the display:
- Max Rows - the maximum number of rows shown in the table preview. (You can set this default in the menu.)
- Max Errors - the maximum number of errors encountered before the preview stops showing more rows (up to the Max Rows value).
- Filter on Column - show only records that contain a specific value in a particular column: select the column in the drop list, then in the Filter string field type the string on which to filter.
- Query Builder - a GUI tool used to define SQL queries for the preview; see Using the Query Builder for more information.
- To exit the preview, click
on the
<table-name> data tab.