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!
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!!
NP, thanks for commenting, lets me know I should keep posting these odd finds I run by and need to use myself.
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.
That works too 🙂
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!
no problemo!
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 *’?
I am sorry, I do not off hand, but any select should cover it, haha.
thank you 🙂
+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!
Not a problem, I always found posts like this helpful, so I try to do my part!
NEVER would have found this without this post. Thanks (6 years later)
No problemo, glad it could help still!