How can I set the number of records / documents displayed per page in Table / Collection Viewer?

Apply OS: Windows, macOS, Linux

Apply Navicat Product: Navicat for MySQL, Navicat for PostgreSQL, Navicat for Oracle, Navicat for SQL Server, Navicat for MariaDB, Navicat for SQLite, Navicat for MongoDB, Navicat Premium

Apply Navicat Version No.: Version 12 or above

To set the limit of records / documents displayed per table / collection, you can find the icon at the right lower corner of the table / collection opened. Click the icon once, then you are able to fill in the number you would like to limit.

If you would like to make it as a global change to all tables / collections:

• Please go to Tools > Options > Records. Then, check the box Limit Records and fill it the numbers of records you would like to be displayed.

• Please go to Navicat XXX > Settings > Records tab. Then, check the box Limit Records and fill it the numbers of records you would like to be displayed.

Please be reminded that the Limit Records checkbox in Options or Settings is a global setting. It will only affect those tables / collections that you haven't set individual limit settings in the viewer.

Assumed you opened an existing table before. For the next time you opened the same table again, the limit record setting will be only based on the table view setting.