removing the limit of 100 rows in squirrel 6

Using the squirrel app: http://www.squirrelsql.org/ I had issues with only seeing 100 rows in a table. I fixed this by going to File -> New Sessions Properties -> Object Tree -> Contents -> limit rows. The default is 100, but you can uncheck it and you should be good.

If not, you can also do the same under New Sessions Properties -> SQL -> SQL Results – limit rows. Then uncheck it and hit OK.

That worked for me!

Facebooktwittergoogle_plusredditpinterestlinkedinmail

6 thoughts on “removing the limit of 100 rows in squirrel

  1. Reply Bello Apr 27,2015 12:57 pm

    Thanks, i’d spent many hours looking for a solution to this problem… saved me big time!!

  2. Reply Vivi The Mage Apr 27,2015 1:26 pm

    NP, thanks for commenting, lets me know I should keep posting these odd finds I run by and need to use myself.

  3. Reply Srinivas Jul 15,2015 8:39 am

    For current session you can use the below option to increase the no.of.rows retrieval:

    Session –> Session properties –> ObjectTree and you set the limit by replacing 100.

    Once you set this property it automatically refresh your current object content to specified limit.

  4. Reply MN Jun 26,2016 11:43 pm

    I tried looking for where this limit was set before but to no avail. Not sure why I didn’t google it sooner but thank you so much for sharing this super useful info. Helps a ton!

Leave a Reply

  

  

  

*