removing the limit of 100 rows in squirrel 11

Using the squirrel app: 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!


11 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!

  5. Reply Selva Jun 2,2017 12:46 pm

    Do you have document for query examples using squirrel SQL? I’m now trying to find how to get the count (number of records) in the table without displaying the records using ‘Select *’?

  6. Reply Vivi The Mage Jun 3,2017 10:13 am

    I am sorry, I do not off hand, but any select should cover it, haha.

  7. Reply Bhavya Oct 25,2017 8:49 am

    thank you 🙂

  8. Reply Jen Jun 21,2018 9:59 am

    +4 years later, this is still a very helpful Google result (I haven’t had a single instance where I don’t want to see ALL the results of my query, thanks SQuirreL lol). Thanks for posting!

  9. Reply Vivi The Mage Jun 21,2018 1:34 pm

    Not a problem, I always found posts like this helpful, so I try to do my part!

Leave a Reply




This site uses Akismet to reduce spam. Learn how your comment data is processed.