Wednesday, October 21, 2009

Squirrel SQL Client Result Display

We all know Squirrel SQL Client is the number one SQL Client which can connect to a variety of databases and offers a intuitive user interface.
But I was just boggled by one of its drawbacks - everytime you issue a query it displays the results in a new tab. Even if you enter the same query again, it will display the results in a new tab.
By the time you have issued about 10-12 queries, it will just keep adding new tabs.
Well, this functionality might be useful for some users and might be seen as "good to have feature", but then there are people like me who are more interested in the principle of res usability :)
I searched through the Global Preferences and even tried to google for a solution, but did not find anything related to this. But surprisingly, the solution is simple enough and does not require any configuration at all!
Just right click on a open tab and select "Toggle Sticky"(the shortcut is Ctrl+Shift+Y) and BINGO!
Hope this will save somebody from brainstorming :)