Sampling the contents of a table

You can display the contents of a table in the Data Output view.

The Data Output view displays a sample of the rows in a table based on the maximum number of rows that is specified in Data > Output page of the Preferences window. You can display up to a maximum of 1000 rows. The number of bytes that are displayed for a character or binary objects in the Data Output view is also specified in the Data > Output page of the Preferences window.

To sample the database table contents:

  1. In the Database Explorer, right-click on the table whose contents you want to display, and then select Data > Sample Contents. Results are displayed in the Data Output view.
  2. Optional: Click the Messages tab to view any messages returned by the database while the statement was running.
Related information
Data extraction and load
Table data editor

Feedback