# Database query browser **URL:** \ **Category:** Ignition\ **Created:** [October 25, 2011, 8:38pm UTC](https://forum.inductiveautomation.com/t/database-query-browser/3490 "2011-10-25T20:38:15Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![Jcam](https://avatars.discourse-cdn.com/v4/letter/j/a88e57/32.png) [@Jcam](https://forum.inductiveautomation.com/u/Jcam)\ **Post date:** [October 25, 2011, 8:38pm UTC](https://forum.inductiveautomation.com/t/database-query-browser/3490/1 "2011-10-25T20:38:15Z")
Is there a setting you can change to get more than 1000 rows to show up in the database query browser that you can use in the ignition designer? ---
**Author:** ![Robert.McKenzie](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/robert.mckenzie/32/4134_2.png) [@Robert.McKenzie](https://forum.inductiveautomation.com/u/Robert.McKenzie)\ **Post date:** [October 25, 2011, 10:08pm UTC](https://forum.inductiveautomation.com/t/database-query-browser/3490/2 "2011-10-25T22:08:57Z")
Yeah, just add a limit to the query in the designer. MySQL:`SELECT * FROM history limit 2000` MSSQL:`SELECT TOP 2000 * FROM history` ---
**Author:** ![Jcam](https://avatars.discourse-cdn.com/v4/letter/j/a88e57/32.png) [@Jcam](https://forum.inductiveautomation.com/u/Jcam)\ **Post date:** [October 26, 2011, 12:08pm UTC](https://forum.inductiveautomation.com/t/database-query-browser/3490/3 "2011-10-26T12:08:06Z")
So there is no setting you can change to show more rows automatically when you open the browser??? ---
**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\ **Post date:** [October 26, 2011, 2:39pm UTC](https://forum.inductiveautomation.com/t/database-query-browser/3490/4 "2011-10-26T14:39:52Z")
No, it is built-in to the query browser.