removing the limit of 100 rows in squirrel

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!

13 replies on “removing the limit of 100 rows in squirrel”

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

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.

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!

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 *’?

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

Leave a Reply

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