Displaying table contents

There are four ways to display the contents of a table, all from the Database Explorer window:

• click on the table, then click on the Display Table menu option or icon, or hit F9.
• click on the table, right-click, then select Table Contents (first 30 rows). This will display a sample of the table (the first 30 rows) in the right-hand grid. Tables will be displayed as you select them by clicking on them (or using the keyboard up and down keys to scroll).
• click on the Run SQL menu option / icon to bring up the Run SQL window. To display the table, click on Run or hit F5. You can use this window to build more complex queries on the table.
• click on Table > Search Table (or the search table icon) will show you the Search Table window. This allows you to select which rows in the table you wish to display. Clicking on OK will display the table.

Once you do any of these the contents will be displayed in the Data Display window.

Not all the rows in the table will be displayed. By default only the first 50 will be shown. This default can be changed by the Options > Display Limits menu option. If you are running the Evaluation version of Advanced Query Tool you will not be able to increase this beyond 50.

For very long columns, by default only the first 200 bytes of the column will displayed. This default can be changed by the Options > Display Limits menu option.