In this article we will cover how to access Squirrel SQL to access any JDBC compliant database. Squirrel SQL is a universal database client, this means that it can be used to access any JDBC compliant RDBMS including Oracle, Sybase, Microsoft SQL Server, Postgresql, MySQL and many others. In Part I of this article we discussed how to set up Squirrel SQL. In this part we will cover how to actually use it, some of the topics to be covered include viewing data in database tables without having to write queries, and how to use Squirrel SQL's auto completion feature to ease the task of writing a SQL query.
To connect to a database, we need to set up a database alias (refer to Part I). All we need to do to connect to the database is double click on the alias.
Then enter the password and click on the "Connect" button".
After connecting to the database, Squirrel SQL should look something like the following screenshot.
The exact way Squirrel SQL looks will depend on the RDBMS used. The screenshot shows how it looks for Postgresql.