Apply OS: Windows, Mac, Linux
Apply Navicat Product: All
Apply Navicat Version No.: All
To set the limit of records displayed per table, you can find the icon Limit Record Setting at the right lower corner of the table opened. Click the icon once, then you are able to fill in the number of records you would like to limit.
If you would like to make it as a global change to all tables:
- For Windows and Linux, please go to Tools > Options > Appearance > Data & Grid, check the box Limit Records and fill it the numbers of records you would like to be displayed.
- For Mac 8.x or above, please go to Main menu > Navicat xxx > Preferences > Grids tab, check the in 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/Preferences window is a global setting. It will only affect those tables that you haven't set individual limit record settings in the table view.
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 Windows's setting.