Limit rows

You can set a limit to the number of rows to display.

Without a limit, you could end up retrieving massive amounts of data. By default, the limit is set to 1000. You can remove all limits by entering zero (0).

When the row limit is met, a message displays in the status area of DB Explorer stating that the limit has been met.

Message displays in status area, stating that the limit of 5 rows reached.

Figure 1. Message displays when limit is met

Regardless of the limit, the data returned always starts with the first row returned by the database server. There is no mechanism to change the order of the rows fetched, or which rows are returned, without altering the SQL by hand.

To set the limit on the number of rows returned:

  1. Select Tools >> Preferences.
  2. Select Meta-Schema manager Preferences.
  3. Under DB Explorer options, specify the maximum number of results (or records) to display and retrieve.