Limiting the Number of Database Rows Fetched

You can prevent the IDE from accidentally trying to fetch thousands of rows.

To limit the number of database rows:

  1. Open the Options window and select the Database Explorer node.
  2. Set the Fetch limit property to the number of rows you want the IDE to fetch without user confirmation (the default is 100).

    When the number of rows returned by a query exceeds this number, the IDE warns you and asks:

  3. Set the Fetch step property to the number of rows you want the IDE to fetch after the fetch limit is reached.
See also
Creating a Table

Legal Notices